Thread: custom format

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

You could use one of the axis label tricks that Jon Peltier explains here:

http://www.peltiertech.com/Excel/Cha...traryAxis.html

John Knoke wrote:
> 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
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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/
_______

Debra Dalgleish wrote:

> You could use one of the axis label tricks that Jon Peltier explains here:
>
> http://www.peltiertech.com/Excel/Cha...traryAxis.html
>
> John Knoke wrote:
>
>> 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
>>
>>
>
>