cell shows formula...not formula result

Daniel Collison

unread,

Sep 9, 2008, 6:18:01 PM9/9/08

to

Infrequently I run across the following problem in excel. I will create a
formula that links a cell to a second cell (i.e. =U11). 99% of the time, the
formula will show the value of the linked cell. Occasionally, the cell will
only show the formula. Typically, I've handled the problem in a variety of
ways. For instance, I may create the link in another cell, and then cut and
paste it to where I want it in the worksheet. Presently, I've a spreadsheet
that has a number of these errors. No matter what work-around I try, the
cell stills shows the formula....but not the formula results. Any
suggestions on how to clean up this problem?

Stefi

unread,

Sep 10, 2008, 7:38:08 AM9/10/08

to

Have you checked Tools>Options>Display tag>Formulae checkbox?

Regards,
Stefi

„Daniel Collison” ezt írta:

Daniel Collison

unread,

Sep 10, 2008, 12:02:01 PM9/10/08

to

I'm running Excel 2003. On the Tools/Options/View menu, I've
checked/unchecked the "formulas" checkbox. This doesn't remedy the
problem...i.e. the cell still shows the formula/link rather than the formula
result.

Stefi

unread,

Sep 11, 2008, 4:36:01 AM9/11/08

to

Then try to check cell format, maybe they are formatted like text!

Simka

unread,

Sep 12, 2008, 7:57:01 AM9/12/08

to

Hi,

1. Format the offending cell to 'General'.
2. Press F2
3. Press <Enter>

This should solve the problem

michaelbuttle

unread,

Dec 10, 2009, 2:48:53 PM12/10/09

to

Hi Simk,

This solution worked very well.

Thank you,
Michael

Simk wrote:

Hi,1. Format the offending cell to 'General'.2. Press F23.
12-Sep-08

Hi,

1. Format the offending cell to 'General'.
2. Press F2
3. Press <Enter>

This should solve the problem

"Daniel Collison" wrote:

Previous Posts In This Thread:

On Tuesday, September 09, 2008 6:18 PM
DanielColliso wrote:

cell shows formula...not formula result

Infrequently I run across the following problem in excel. I will create a
formula that links a cell to a second cell (i.e. =U11). 99% of the time, the
formula will show the value of the linked cell. Occasionally, the cell will
only show the formula. Typically, I've handled the problem in a variety of
ways. For instance, I may create the link in another cell, and then cut and
paste it to where I want it in the worksheet. Presently, I've a spreadsheet
that has a number of these errors. No matter what work-around I try, the
cell stills shows the formula....but not the formula results. Any
suggestions on how to clean up this problem?

On Wednesday, September 10, 2008 7:38 AM
Stef wrote:

Have you checked Tools>Options>Display tag>Formulae checkbox?
Have you checked Tools>Options>Display tag>Formulae checkbox?

Regards,
Stefi

???Daniel Collison??? ezt ??rta:

On Wednesday, September 10, 2008 12:02 PM
DanielColliso wrote:

I'm running Excel 2003.
I'm running Excel 2003. On the Tools/Options/View menu, I've
checked/unchecked the "formulas" checkbox. This doesn't remedy the
problem...i.e. the cell still shows the formula/link rather than the formula
result.

"Stefi" wrote:

On Thursday, September 11, 2008 4:36 AM
Stef wrote:

Then try to check cell format, maybe they are formatted like text!
Then try to check cell format, maybe they are formatted like text!

Regards,
Stefi

???Daniel Collison??? ezt ??rta:

On Friday, September 12, 2008 7:57 AM
Simk wrote:

Hi,1. Format the offending cell to 'General'.2. Press F23.
Hi,

1. Format the offending cell to 'General'.
2. Press F2
3. Press <Enter>

This should solve the problem

"Daniel Collison" wrote:

Submitted via EggHeadCafe - Software Developer Portal of Choice
ASP.NET 1.1 to ASP.NET 2.0 Migration Solutions
http://www.eggheadcafe.com/tutorials/aspnet/03cedfc8-e623-4fee-81d8-04663b71b675/aspnet-11-to-aspnet-2.aspx