Thread: Unwanted result
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Patrick C. Simonds Patrick C. Simonds is offline
external usenet poster
  
Posts: 343
Default 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.


Reply With QuoteReply With Quote