cell shows formula...not formula result

[Daniel Collison]

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]

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

Regards,
Stefi

„Daniel Collison†ezt írta:

 

[Daniel Collison]

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]

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

Regards,
Stefi

„Daniel Collison†ezt írta:

 

[Simka]

Hi,

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

This should solve the problem

 

[Michael Buttle]

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 F
3. Press <Enter

This should solve the proble


:

Previous Posts In This Thread:

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?

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

Regards
Stef

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

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



:

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
Stef

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

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

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

This should solve the proble


:


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