pretty easy help needed for mph formula

[Hoffman]

Hi all,
Thanks for reading and offering a simple solution.

I have a cell that uses a formula =O54*60 that tells me speed in mph. In the cell it just shows the mph number. i.e. 23.4

I would like to have mph appear after the number in the same cell like
23.4 mph

I read how to do this and got it but I also need the number rounded to to the tenths which I could not do by hitting the Decrease Decimal button as it would not adjust the number (many decimal places appeared) since the text was with it.

Can you please help me write the needed formula that would get the mph number and have mph appear after the number in the same cell and rounded to tenths.

Thanks!!

Barry

 

[6StringJazzer]

The best way to do this is to use the following custom format:

0.0 \MP\H

The 0.0 says "show the number rounded to 1 decimal place" This does not mean that the number is rounded to 1 decimal place, only that the number displayed is rounded.
The \ characters are needed because m and h are used to indicate minutes and hours, so you need a \ if you just want the actual letters.

$scratch.xlsm
	A	B
1	31.3 MPH	31.26
Sheet8

Cell Formulas
Range	Formula
A1	A1	=O1*60
B1	B1	=O1*60

 

[Hoffman]

The best way to do this is to use the following custom format:

0.0 \MP\H

The 0.0 says "show the number rounded to 1 decimal place" This does not mean that the number is rounded to 1 decimal place, only that the number displayed is rounded.
The \ characters are needed because m and h are used to indicate minutes and hours, so you need a \ if you just want the actual letters.

$scratch.xlsm
	A	B
1	31.3 MPH	31.26
Sheet8

Cell Formulas
Range	Formula
A1	A1	=O1*60
B1	B1	=O1*60

thanks that seemed to work!!

Barry

 

[smozgur]

thanks that seemed to work!!

Barry

The marked solution has been switched accordingly.