You can just add a comma to each of the arguments in any of the number
formats, and it will reduce the visual value by a factor of 1,000. Two
commas will reduce by 1,000,000 and so on.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"William Copeland" wrote in message
...
I use Excel 2000. Is there anyway to format numbers in 1000's? Right now
I
divide each cell by 1000 to get the results I want
(=5,000,000.00/1000=5,000) and format to zero decimals.
Thanks