<div>
Use this format...<br />
<br />
#,##0.00,, &quot;M&quot;<br />
<br />
Saurabh...
</div>


Use this format...

#,##0.00,, "M"

Saurabh...

<div>
Thanks Saurabh but that is returning 0.00 M
</div>


Thanks Saurabh but that is returning 0.00 M

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a number that displays as 40,556,062<br />
<br />
When I add data points the graph shows 41, how can I custom format it so it shows $40.57 M<br />
<br />
Currently the custom format is #,##0.00<br />
<br />
Thanks!
</div>
</div>


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!

Number format

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.