You can do it with Excel

Type 1000 into a spare cell

Copy that cell

Select the range to divide in to

Goto EditPastespecial

Click the Divide option

OK

Clear that spare cell

--
__________________________________
HTH

Bob

"Abdul Shakeel" wrote in message
...
Hi All,

Is there is any macro to divide a cell or range by 1000