Automuliply

[Guest]

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.

 

[Max]

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

--