how do I show results in the same cell I entered my value?

[mfass]

Ok, heres my problem: I can enter a value into a cell, and write a formula to take a percentage of that value (ie: =(A1*60%) where A1=100, the new value will be 60). I want to display the new value of A1 directly into A1. So that every time I enter a new value, it automaticaly takes the percentage of that value and shows it in the box where i originaly entered the value. I hope that makes sense... its driving me nuts.

Please email me with answers @ [email protected]

[tkaplan]

If anyone comes up with any answers, can you please post them because I cant think of any way to do that - any value you put in will overright the formula!

[MrShorty]

The only way I can think of doing this is using a VBA Sub procedure that is associated with an onchange, onentry, or similar event.

Sub mytest()
temp=activecell.value
temp2=0.6*temp
activecell.value=temp2
end sub

It's crude and untested, but see if that gets you started.