Custom Formatting numbers question

I have a spreadsheet with lot of millions numbers floating around. When I
make graphs out of it, there's too much zeros.

I don't want to divide all the numbers per 1 million.

Is there a way to custom format those numbers with a mask that would take
care of that problem for me ?

i.e. 7 456 890.98$ would be represented with 7,457 M$

tia

Double-click the numbers on your chart. Hit the Scale tab. From the Display
units drop-down, choose Millions.
*******************
~Anne Troy

www.OfficeArticles.com


"Junkyard Engineer" <[email protected]> wrote in message
news:OwHdgn%[email protected]...
> I have a spreadsheet with lot of millions numbers floating around. When I
> make graphs out of it, there's too much zeros.
>
> I don't want to divide all the numbers per 1 million.
>
> Is there a way to custom format those numbers with a mask that would take
> care of that problem for me ?
>
> i.e. 7 456 890.98$ would be represented with 7,457 M$
>
> tia
>
>

Thanks

"Anne Troy" <[email protected]> a écrit dans le message de
news:[email protected]...
> Double-click the numbers on your chart. Hit the Scale tab. From the
Display
> units drop-down, choose Millions.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
>
>
> "Junkyard Engineer" <[email protected]> wrote in message
> news:OwHdgn%[email protected]...
> > I have a spreadsheet with lot of millions numbers floating around. When
I
> > make graphs out of it, there's too much zeros.
> >
> > I don't want to divide all the numbers per 1 million.
> >
> > Is there a way to custom format those numbers with a mask that would
take
> > care of that problem for me ?
> >
> > i.e. 7 456 890.98$ would be represented with 7,457 M$
> >
> > tia
> >
> >
>
>