Thread: Custom Number Format to abbreviate to Millions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Custom Number Format to abbreviate to Millions
Pierre wrote:
Would like to show in a chart:
Value is: 1,248,236
Would like shown as: 1.25M
or
Value is: 457,692
Would like shown as: 0.46M

This one escapes me.

TIA for any ideas.
Pierre


Try this:

#.00,,"M"
Reply With QuoteReply With Quote