This might suffice ..

Click Tools Options Edit tab
Check "Fixed decimal" and set the Places to: -3
Click OK

Test it out, you'd get the results ..
.. if I enter 2 the result must be 2000 and so on

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"John Britto" wrote in message
...
If I enter a figure in a cell it should automatically multiply.
example: a cell value 1000 (hidden or visible) and if I enter 2 the
result
must be 2000 and so on... any help.