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

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.