Excel 2002: How to reveal a formula in a cell ?
Dear Sir,
Thanks for the tip.
Low
--
A36B58K641
"Cimjet" wrote:
Hi Mr. Low
Press on Ctrl+` (Accent grave) key before number 1 to unhyde/hyde formulas.
Regards
Cimjet
"Mr. Low" wrote in message
...
Dear Sir
If I have formula at =SUMIF(A$1:A$20,C20,D$1:D$20) at cell F1,
May I know the quick way to reveal the formula as a text i,e.
€˜=SUMIF(A$1:A$20,C20,D$1:D$20) ?
Currently I could only read from the formula bar , I need to go to the bar
and key in €˜ in front of it in order for it to be shown as text.
Thanks
Low
--
A36B58K641
|