Format number / 1000

[Jac Tremblay]

Hi,
I wanderif there is a format (personalized) in Excel that would display a
number as the number divided by 1000. For example, 1 000 000 would appear as
1 000 (or 1,000,000 as 1,000).
Something like the % format that multiplies the number by 100 to display it.
Thanks
--
Jac Tremblay

[Andrew Taylor]

Jac,
Try this: #,##0, <<< note comma at end

(replace the first comma by a space for your first example)

hth
Andrew

Jac Tremblay wrote:
> Hi,
> I wanderif there is a format (personalized) in Excel that would display a
> number as the number divided by 1000. For example, 1 000 000 would appear as
> 1 000 (or 1,000,000 as 1,000).
> Something like the % format that multiplies the number by 100 to display it.
> Thanks
> --
> Jac Tremblay

[Chip Pearson]

Jac,

Use a custom number format of

#,##0,

Note the trailing comma.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
news:D55D12A4-E792-4E8C-9217-9A55A6EE0DB4@microsoft.com...
> Hi,
> I wanderif there is a format (personalized) in Excel that would
> display a
> number as the number divided by 1000. For example, 1 000 000
> would appear as
> 1 000 (or 1,000,000 as 1,000).
> Something like the % format that multiplies the number by 100
> to display it.
> Thanks
> --
> Jac Tremblay

[Jac Tremblay]

Hi Andrew,
You are right. It works fine. Here is some more information for all the
community and especially for french users.
For French format (space as the thousand separator and comma for the decimal
separator), one has too add a space at the end like this "# ##0,00 " for 2
decimals and like this "# ##0 " for 0 decimals.
If one wants to keep the $ sign, "# ##0,00 $" for 2 decimals and "# ##0 "
for 0 decimals.
Note: I always wandered why "0 decimals" takes an "s" in english...
Thank you very much, Andrew. You make my day.
--
Jac Tremblay


"Andrew Taylor" wrote:

> Jac,
> Try this: #,##0, <<< note comma at end
>
> (replace the first comma by a space for your first example)
>
> hth
> Andrew
>
> Jac Tremblay wrote:
> > Hi,
> > I wanderif there is a format (personalized) in Excel that would display a
> > number as the number divided by 1000. For example, 1 000 000 would appear as
> > 1 000 (or 1,000,000 as 1,000).
> > Something like the % format that multiplies the number by 100 to display it.
> > Thanks
> > --
> > Jac Tremblay
>
>

[Jac Tremblay]

Hi Chip,
Thanks for your answer. I replied to Andrew who posted first. My reply
applies to you as well and includes some more information for french users.
Thanks a lot to you too.
--
Jac Tremblay


"Chip Pearson" wrote:

> Jac,
>
> Use a custom number format of
>
> #,##0,
>
> Note the trailing comma.
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
>
>
> "Jac Tremblay" <jac.tremblay@donotspam.com> wrote in message
> news:D55D12A4-E792-4E8C-9217-9A55A6EE0DB4@microsoft.com...
> > Hi,
> > I wanderif there is a format (personalized) in Excel that would
> > display a
> > number as the number divided by 1000. For example, 1 000 000
> > would appear as
> > 1 000 (or 1,000,000 as 1,000).
> > Something like the % format that multiplies the number by 100
> > to display it.
> > Thanks
> > --
> > Jac Tremblay
>
>
>

[myowntest]

Hi,
This format is working for data which is present in the excel cells. But not working for the graph.
Graph is not showing values by dividing 1000 as well as space as thousand separator
Graph Axis label also not working for the French users.
where as for all US/English users it is working fine. Graph values and axis values are showing correctly by dividing with 100o and comma separated/ Only French is having issue.
Please provide some pointers for French format issue with Graph

[jeffreybrown]

Hello myowntest & Welcome to the Forum,

As this thread is seven years old, the original helpers in this thread may not respond anytime soon.

Administrative Note:

• Somebody would be happy to help with your query, but first, before we can proceed…
• Please see Forum Rule #2...Do not post a question in the thread of another member -- start your own thread..
• If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
• Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.