one way:

Format/Cells/Number/Custom 0,000,

In article . com,
wrote:

Hi,

Actually, i have made a very complex worksheet and i don't want to
apply any formula over the worksheet cells.

Therefore, i need to apply cell format on the worksheet in such a
manner that it shows desired cells values in thousands.

Let say if cell A1= 1,000,000 but i want it to show a 1,000 or if Cell
B1=2,567,908 then it would shown to meas 2,568 only


Keep in mind that i don't want to apply any formula to this worksheet.

Thanks in anticipation!
Adnan Abbasi