Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automuliply
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|