SOLVED
Home

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

SJD-Fairfax
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
Solution

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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies