copying Formulatext() and pasting the value only

[lezawang]

Hi
I wrote this formula

A1=10+20

B1=Formulatext(A1)

Then I copied B1 and pasteSpecial-->Value into the same B1 and I got

B1 =10+20

I clicked on B1 and the format is general. My question, why excel kept the formula in B1 =10+20 rather than giving me the result of the formula which is 30

If I pick any cell lets say C1 and enter =10+20, I would see 30, not =10+20

Thank you

 

[jtakw]

@jtakw

I'm afraid that doesn't happen for me, no matter what the format....formulatext remains as the text from A1

No Michael, I mean After you copied and pasted B1 -which contains the formula =FORMULATEXT(A1) - back to B1 as "Value", if B1 is still formatted "general", click into B1, hit Enter, it will evaluate the formula of the Text of =10+20 and return 30

 

[Michael M]

aah, got it....but it did require double click, then Enter..

 

[jtakw]

That's what I meant by "click into the cell", 1 click "selects" the cell, 2 clicks, you're actually in the cell...