Dear McGimspey,

Thanks you, and sorry for ignoring such minute thing "," "a comma after
0".

thanks once again!
best regards,
adnan

On Jan 18, 3:26 pm, JE McGimpsey wrote:
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- Hide quoted text -- Show quoted text -