Thread: custom formats
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
  
Posts: 561
Default custom formats
You may try this: 0.##,,"M"
Micky


"Flipper" wrote:

How can I format 31,840,000 to appear as 31.84M, and or 35,000,000 as 35M?

Thanks
--
Allan
Reply With QuoteReply With Quote