Thread: Remove decimal but keep entire number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tickfarmer Tickfarmer is offline
external usenet poster
  
Posts: 17
Default Remove decimal but keep entire number
I need the price to display with no decimal, but retaining the numbers that
appear after the decimal. For example $47.50 would be 4750.
Example 119.00 would be 11900
Please help

--
Tickfarmer
Reply With QuoteReply With Quote