View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] adnan.adnanabbasi@gmail.com is offline
external usenet poster
 
Posts: 6
Default Excel format Cell

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