View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jasmine[_2_] Jasmine[_2_] is offline
external usenet poster
 
Posts: 4
Default Remove decimals but keep numbers

Is there a way with Excel to remove the decimals from a
number but keep all the digits? For example, if I have a
cell that is in a number format with 123.40, I want it to
look like 12340. Any help would be appreciated.