How do I view formula results intead of formula in excel?

D

davidinatlanta

I have a spreadsheet that someone email me and I am trying to add a formula
to it. Instead of the cell showing the results of the formula, it just shows
the actual formula, "=VLOOKUP(F2,'[02-06-06 National Accounts with SC & CSA
Info.xls]Sales Transformation Data'!$N$3:$O$3525,2,FALSE)"

I tried Ctrl ` as suggested from Microsoft Help, but that seemed to toggle
the column widths.
 
D

Dav

Try tools, options,view,windows options, untick the formulas box if it
is ticked

regards

Dav
 
A

Arvi Laanemets

Hi

2 possible reasons.
a) All cells with formulas are formatted as text. Format them as
General/Number/Date etc., and then replace all "=" with "=" (Edit>Replace
from menu).
b) 'Formulas' is checked in Tools>Options>View. Uncheck it
 
B

Bernard Liengme

Hi David,
CTRL+` (the accent on the key next to 1 on top row of typewriter keys)
should work
If not, try Tools | Options; open View tab; look in lower part (Window
options) and uncheck Formulas
best wishes
 
D

davidinatlanta

Thank you all for your quick posts. I tried your suggestions to no avail. I
looked at a different spreadsheet to see if the ctrl + ` works and it did
there. But for some reason, it doesn't want to work in this one. I selected
the entire spreadsheet and changed the format to General, I changed out all
the "=" with "=", it is still a mystery.

Arvi Laanemets said:
Hi

2 possible reasons.
a) All cells with formulas are formatted as text. Format them as
General/Number/Date etc., and then replace all "=" with "=" (Edit>Replace
from menu).
b) 'Formulas' is checked in Tools>Options>View. Uncheck it



--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )



davidinatlanta said:
I have a spreadsheet that someone email me and I am trying to add a formula
to it. Instead of the cell showing the results of the formula, it just
shows
the actual formula, "=VLOOKUP(F2,'[02-06-06 National Accounts with SC &
CSA
Info.xls]Sales Transformation Data'!$N$3:$O$3525,2,FALSE)"

I tried Ctrl ` as suggested from Microsoft Help, but that seemed to toggle
the column widths.
Click to expand...
Click to expand...
 
Top