Thread: Rounding off or Converting Numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
  
Posts: 1,091
Default Rounding off or Converting Numbers
If the number is in A1, then in B1 =ROUNDUP(A1,0)

tyro

"hsaryfm" wrote in message
...
How to convert 0.1 to 1

or

5.11125 to 6.000


Reply With QuoteReply With Quote