custom format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to custom format my Y axis the only on the top number of the scale to
appear with the $ sign and the rest of the numbers #,###. Thanks
 
A simpler solution is to change the number format.

This won't work if you have no idea a priori what the max will be, but
if you know it's 10,000, double click the axis, click on the Number tab,
select Custom in the left side, and type this in the entry box:

[=10000]$#,##0;#,##0

If you know it's going to be at least 10,000, but aren't sure exactly
what, use this:

[>=10000]$#,##0;#,##0

Visit the page below to read more about the magic of number formats:

http://peltiertech.com/Excel/NumberFormats.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top