how to format cells so that it only shows thousands.

[sokevin]

howdy,


i want to format cells so that

number like

1,234,567 = 1,234 or 1235


how can i do this other than divide by 10.

i just want to use the format number feature.


thanks

kev :

 

[Frank Kabel]

Hi
try the custom format
0,

or use
0,0,