Number format

Hi,

I have a number that displays as 40,556,062

When I add data points the graph shows 41, how can I custom format it so it shows $40.57 M

Currently the custom format is #,##0.00

Thanks!
Seamus2626Asked:
Who is Participating?
 
Saurabh Singh TeotiaCommented:
If you have data less then a million it will show that 0.00 M, However if the data is more then a million it will give you a desired result what you are looking for which is-->40,556,062 get converted to-->40.56 M
0
 
Saurabh Singh TeotiaCommented:
Use this format...

#,##0.00,, "M"

Saurabh...
0
 
Seamus2626Author Commented:
Thanks Saurabh but that is returning 0.00 M
0
 
Rgonzo1971Commented:
Are you sure that you your Axis Option

Display Units is None and not Millions?

Regards
0
 
Seamus2626Author Commented:
Perfect lads, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.