Thread: Unwanted result
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sunday88310 Sunday88310 is offline
external usenet poster
 
Posts: 103
Default 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.