Thread: Custom Number Format to abbreviate to Millions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
  
Posts: 193
Default Custom Number Format to abbreviate to Millions
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
Reply With QuoteReply With Quote