How do I display millions and billions like this $15M or $10B and still be able to calculate it?

New Contributor

I need to create a chart for a client that uses these formats, such as $0.2B or $10M and since it's a bar chart, I need it to pick up the values.

3 Replies

You could use a custom cell format for your source data, not sure exactly where you want to break from M to B or how much you want the displayed numbers rounded though. Ex:


[>99999999]#.##,,," B";[>99999]#.##,," M"


Thank you for your response, but I'm not sure how to use your custom cell formula.




Nevermind, I figured it out.  Thanks again.  It was a big help!

Related Conversations
Hiding object/page URL info at bottom of page
Demi- in Discussions on
1 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Excel User Interface (UI) Freezing
Stuart-Signify in Excel on
3 Replies
Gain your competitive edge through ITFM
TiffanyRose in IT Transformation on
0 Replies
Gain your competitive edge with ITFM
TiffanyRose in IT Resources & Training on
0 Replies