Thread: Custom Number formatting

Hi guys,

I have a bunch of big numbers 1'000'000, 900'000 etc... and would like to
format them in order to cut last 3 zeros (for chart visualisation purposes).
I suppose that the adequate formatting could be something like #.##/1000,
but this one is not working..

Could you pls help me on this?
Thanx,

I'm not sure if this is any help, but with the chart axis, there is an option 'Display units' where you can choose hundreds, thousands, billions and so on.

Try (US format, adjust to suit):

#,##0,

In article <ebbr0oJ9EHA.2608@TK2MSFTNGP10.phx.gbl>,
"gizmo" <gizmo@discussions.com> wrote:

> I have a bunch of big numbers 1'000'000, 900'000 etc... and would like to
> format them in order to cut last 3 zeros (for chart visualisation purposes).
> I suppose that the adequate formatting could be something like #.##/1000,
> but this one is not working..

Thanks a lot for your suggestion!

The format you suggested replaced "1'000'000" by "1000,000," (which was
probably due to my comp's settings), but then I've found (by trial and
error, inspired by your input) the one that is fuctionning perfectly (giving
simply "1000"). In my case it was #'

Cheers,
Gizmo


"JE McGimpsey" <jemcgimpsey@mvps.org> wrote in message
news:jemcgimpsey-3F06B5.08390707012005@msnews.microsoft.com...
> Try (US format, adjust to suit):
>
> #,##0,
>
> In article <ebbr0oJ9EHA.2608@TK2MSFTNGP10.phx.gbl>,
> "gizmo" <gizmo@discussions.com> wrote:
>
> > I have a bunch of big numbers 1'000'000, 900'000 etc... and would like
to
> > format them in order to cut last 3 zeros (for chart visualisation
purposes).
> > I suppose that the adequate formatting could be something like
#.##/1000,
> > but this one is not working..

Hi,

Just for the record; here are two good sources:
http://www.mvps.org/dmcritchie/excel....htm#getformat
http://support.microsoft.com/?scid=k...d=1743&sid=340

And examples how to use it:
# # : 1 000 000 (#blank#)
# # ' : 1 000' (#blank#blank')
# '' : 1'' (#blankblank'') that is two '
+
#.### ' : 1.000'

Ola