Formula shows only as formula in cell - why can't I change it?

[Louise99]

I have tried in every way to show my data in a cell where the formula =d3-c3 resides. I can't get the answer to show up. I have used f9, calculate, tools-options. What else can I do? This has happened before, but I can't remember what my co-worker did to resolve the problem.

Any suggestions? THANKS!

Peace,
krfb

Thanks!kb

 

[SkipVought]

Hi,

Tools/Options - View Tab - Window Options Area - Uncheck Formulas CheckBox

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[Louise99]

Thanks, Skip. I tried that and it didn't work! I thought doing that would be the sure fix. Also, I made sure the workbook wasn't protected or anything. What do you think?

Thanks!kb

 

[SkipVought]

change the cell format to General, edit the formula, [enter]

Skip,

_{[red]Be advised:[/red] It's been reported that a wee psychic is roaming the countryside.
Small Medium @ Large!}

 

[byundt]

If the first character isn't an = sign, then the formula won't compute. Click just to the left of the = sign and backspace. If the cursor moves, then you have solved the problem.