Delete "$-" at zero on Y axis?

[Bob@1800-mail.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!

[Mike Middleton]

Bob@1800-mail.com -

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

<Bob@1800-mail.com> wrote in message
news:1144190015.905765.225470@t31g2000cwb.googlegroups.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!
>

[Bob@1800-mail.com]

Thanks, that fixed it.

Mike Middleton wrote:
> Bob@1800-mail.com -
>
> 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
>
> <Bob@1800-mail.com> wrote in message
> news:1144190015.905765.225470@t31g2000cwb.googlegroups.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!
> >