Hoffman
Board Regular
- Joined
- Oct 19, 2007
- Messages
- 220
- Office Version
- 365
- Platform
- MacOS
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
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