Automuliply

J

John Britto

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.
 
M

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 ..
 
Top