| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unwanted result
I am using the folowing formula:
=I4 &" MPH" The problem is I can not format the cell to limit the number to just 1 number right of the decimal point. I end up with a result like 28.1587433224 MPH. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unwanted result
Pat how's it going
How about try =roundup in your cell -- William McNulty OfficeSpecialist/2003 "Patrick C. Simonds" wrote: I am using the folowing formula: =I4 &" MPH" The problem is I can not format the cell to limit the number to just 1 number right of the decimal point. I end up with a result like 28.1587433224 MPH. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unwanted result
try = text(i4,"0.0") & " MPH"
Steve On Thu, 22 Feb 2007 04:14:51 -0000, Patrick C. Simonds wrote: I am using the folowing formula: =I4 &" MPH" The problem is I can not format the cell to limit the number to just 1 number right of the decimal point. I end up with a result like 28.1587433224 MPH. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Unwanted result
Patrick
=TEXT(I4,"###.0")&" mph" Gord Dibben MS Excel MVP On Wed, 21 Feb 2007 20:14:51 -0800, "Patrick C. Simonds" wrote: I am using the folowing formula: =I4 &" MPH" The problem is I can not format the cell to limit the number to just 1 number right of the decimal point. I end up with a result like 28.1587433224 MPH. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
| excel result return wrong calcuation result | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
| Unwanted LOOKUP() Result | Excel Discussion (Misc queries) | |||
Hybrid Mode
