Yes, this works perfectly and it was so easy. Thanks.

"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