Delete "$-" at zero on Y axis?
 

I have a chart with the Y axis formated in dollars, zero cents, and I
want to get rid of the first dollar sign and dash that appears at the
zero point on the Y axis.

Is there a way to do this without changing the minimum value? (And keep
the dollar format.)


Thanks!

Delete "$-" at zero on Y axis?
 

-

One way is to not use the "Currency Style" button on the formatting toolbar.

Instead, select the axis, and choose Format Selected Axis | Number |
Currency, with the appropriate settings.

- Mike
www.mikemiddleton.com

wrote in message
oups.com...
I have a chart with the Y axis formated in dollars, zero cents, and I
want to get rid of the first dollar sign and dash that appears at the
zero point on the Y axis.

Is there a way to do this without changing the minimum value? (And keep
the dollar format.)


Thanks!

Delete "$-" at zero on Y axis?
 

Thanks, that fixed it.

Mike Middleton wrote:
-

One way is to not use the "Currency Style" button on the formatting toolbar.

Instead, select the axis, and choose Format Selected Axis | Number |
Currency, with the appropriate settings.

- Mike
www.mikemiddleton.com

wrote in message
oups.com...
I have a chart with the Y axis formated in dollars, zero cents, and I
want to get rid of the first dollar sign and dash that appears at the
zero point on the Y axis.

Is there a way to do this without changing the minimum value? (And keep
the dollar format.)


Thanks!