View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default How do I view formula results intead of formula in excel?

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"davidinatlanta" wrote in message
...
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.