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.

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.

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.

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.