Automated Calculation

[manoj_excel]

I need to enter numbers in some columns on an excel sheet.When i enter the numbers the number should automatically multiply with a fixed value.
For eg I want that all the numbers entered in column c to be multiplied with 5.Hence when I enter 5 it should automatically display 25.Is this possible ,if so please advise.
Thank you
Manoj

 

[tmcfadden]

Check out this post:

http://www.mrexcel.com/board2/viewtopic.php?t=235313&highlight=

There's a macro in there that needs to be changed, but it's the same process.

-Tim