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,
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,

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" wrote in message
...
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

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

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" wrote in message
...
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