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

 

[Andrew Taylor]

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

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

hth
Andrew

 

[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]

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]

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.