Unwanted result

[Patrick C. Simonds]

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.

 

[Sunday88310]

Pat how's it going

How about try =roundup in your cell

 

[SteveW]

try = text(i4,"0.0") & " MPH"

Steve

 

[Gord Dibben]

Patrick

=TEXT(I4,"###.0")&" mph"


Gord Dibben MS Excel MVP