PC Review


Reply
Thread Tools Rate Thread

formula displays as a formula, not as its result

 
 
dido22
Guest
Posts: n/a
 
      25th Jan 2012
Hi,

I am using excel 2007.

I have a simple formula in a cell , the cell displays the formula, not its
result.

I have checked under excel options/advanced/worksheet, the option 'show
formulas ....' is un checked.

Formats are set to 'general'

Help please ?

Thanks

KK

 
Reply With Quote
 
 
 
 
GS
Guest
Posts: n/a
 
      25th Jan 2012
dido22 submitted this idea :
> Hi,
>
> I am using excel 2007.
>
> I have a simple formula in a cell , the cell displays the formula, not its
> result.
>
> I have checked under excel options/advanced/worksheet, the option 'show
> formulas ....' is un checked.
>
> Formats are set to 'general'
>
> Help please ?
>
> Thanks
>
> KK


Maybe...
Did you change the cell format to "General" after you entered the
formula? If so, select the cell, hit F2, hit Enter. The formula should
now show a return value.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula displays as formula, not as result Empque Microsoft Excel Misc 2 22nd Jan 2009 03:04 PM
Formula or function displays after edit and not its result DaveR Microsoft Excel Worksheet Functions 3 17th Jan 2008 08:48 PM
Formula displays result in formula box but not in cell =?Utf-8?B?YmR5ZXIzMA==?= Microsoft Excel Misc 0 8th Feb 2006 12:16 PM
Formula displays result in formula box but not in cell =?Utf-8?B?YmR5ZXIzMA==?= Microsoft Excel Worksheet Functions 0 8th Feb 2006 12:16 PM
insert formula using VB - displays formula as string, not result Dom Boyce Microsoft Excel Discussion 1 27th Feb 2004 11:08 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:59 PM.