formula for changing numbers in axis data labels?

[Genevieve]

Hi, I was hoping someone could tell me the formula for changing the axis
label numbers from:

$73,852,763
to
$73.9M

I tried all of the options in the custom section, but I can't seem to figure
it out.

Help please!

Thanks.

 

[Echo S]

Great question!

http://msdn2.microsoft.com/en-us/library/0c899ak8.aspx helped me figure it
out.

$#,##0.0,,"M" did it for me using your example number.

 

[Genevieve]

Awesome. Thanks for your help!

Great question!

http://msdn2.microsoft.com/en-us/library/0c899ak8.aspx helped me figure it
out.

$#,##0.0,,"M" did it for me using your example number.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

Hi, I was hoping someone could tell me the formula for changing the axis
label numbers from:

$73,852,763
to
$73.9M

I tried all of the options in the custom section, but I can't seem to
figure
it out.

Help please!

Thanks.