Format 5.5M on a chart

[tommyfernandez]

Hello,

I have a chart with values like "5,000,000" and "5,500,000". How do I format it so it shows 5M and 5.5M on the axis?

Thanks, in advance, for your help!

-Tommy

[MrShorty]

Available number format codes: https://support.office.com/en-US/art...2-09fab54be7f4

Use of the comma to scale a number is described about half way down. Adding the text M is described at the top. Something like 0,,\M should be what you are looking for.

[tommyfernandez]

That's exactly what I needed.. Thank you, MrShorty!!

-Tommy