Re: How to reveal a formula in a cell ?

Typically, one selects a block and does a File > Print Preview.  Then 
change the Setting's Options to print formulas.

Low:
> May I know the quick way to reveal the formula as text i.e. 
> '@SUMIF(A$1:A$20,C20,D$1:D$20) ?
>
Select the Cell.
Format|Selection|Numeric format|(x)Text|[OK]
-- 
Good wishes!
Roy Lewis
C_Tech volunteer
(UK)

Dear Sir

I have formula @SUMIF(A$1:A$20,C20,D$1:D$20) at cell F1,

May I know the quick way to reveal the formula as text i.e. 
'@SUMIF(A$1:A$20,C20,D$1:D$20) ?

Currently I can only read from the formula bar , I need to go to the bar and 
key in  '  in front of it to reveal it as text.

Thanks

Low

:

Hello Kanneth,

Thanks for the tip.

Low

"Kenneth Hobson" <khobson@aaahawk.com> wrote in message 
news:47ebabcf$1_2@cnews...
>
> Typically, one selects a block and does a File > Print Preview.  Then 
> change the Setting's Options to print formulas.
> 

Hi Seng,
right click mouse anywhere on screen, choose "properties", choose 
"format of numbers", mark "text", then "ok".
Ready.
The cell shows the formula (not the result of computing.
Tycho



Low Seng Kuang schrieb:
> Dear Sir
> 
> I have formula @SUMIF(A$1:A$20,C20,D$1:D$20) at cell F1,
> 
> May I know the quick way to reveal the formula as text i.e. 
> '@SUMIF(A$1:A$20,C20,D$1:D$20) ?
> 
> Currently I can only read from the formula bar , I need to go to the bar
and 
> key in  '  in front of it to reveal it as text.
> 
> Thanks
> 
> Low
> 
> :
> 
> 
> 
>