ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   when i type a formula in excel i can see the formula only (https://www.excelbanter.com/excel-discussion-misc-queries/203679-when-i-type-formula-excel-i-can-see-formula-only.html)

santhosh

when i type a formula in excel i can see the formula only
 
can somebody help me its urgent please

Sheeloo[_2_]

when i type a formula in excel i can see the formula only
 
In Excel 2003 go to Tools-Options-View Tab

Uncheck the 'Formulas' checkbox in the Windows Options block...

OR

You can press (once only) CTRL-~ keys together :-)

"Santhosh" wrote:

can somebody help me its urgent please


David Biddulph[_2_]

when i type a formula in excel i can see the formula only
 
On my keyboard it is Ctrl `, not Ctrl ~

Another possible explanation is that the cell may be formatted as text. If
so, format as general and then re-enter the formula.
--
David Biddulph

"Sheeloo" wrote in message
...
In Excel 2003 go to Tools-Options-View Tab

Uncheck the 'Formulas' checkbox in the Windows Options block...

OR

You can press (once only) CTRL-~ keys together :-)

"Santhosh" wrote:

can somebody help me its urgent please




Sheeloo[_2_]

when i type a formula in excel i can see the formula only
 
You are right, David. My mistake...

"David Biddulph" wrote:

On my keyboard it is Ctrl `, not Ctrl ~

Another possible explanation is that the cell may be formatted as text. If
so, format as general and then re-enter the formula.
--
David Biddulph

"Sheeloo" wrote in message
...
In Excel 2003 go to Tools-Options-View Tab

Uncheck the 'Formulas' checkbox in the Windows Options block...

OR

You can press (once only) CTRL-~ keys together :-)

"Santhosh" wrote:

can somebody help me its urgent please






All times are GMT +1. The time now is 11:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com