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

See one answer to your identical question in microsoft.public.excel.misc

Please don't post the same question in multiple groups - it just tends
to fragment your answers.


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

Go to Format Cells, choose CUSTOM and
set your format as follows: #,###,

Hope this helps
Rakesh Dilraj

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