formating (000)

[John]

Is there any way I can format numbers so only thousands
show.
Instead of:
100,000 I'd like to show 100
1,000,000 I'd like to show 1,000

(I can just specify in the column heading that all
numbers are (000).)

Is this done using custom formats? Going through and
dividing by 100 seems like a pain.

Thank you

 

[Frank Kabel]

Hi
try the custom format
0,.0