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