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

Posted to microsoft.public.excel.worksheet.functions

davidinatlanta

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel practice sheet. Can't view instructions.	Lindyloo	Excel Discussion (Misc queries)	0	February 5th 06 07:21 PM
When running a SAP report Excel will only display results if Excel isn't already open	peternoy	Excel Discussion (Misc queries)	0	January 19th 06 11:03 AM
View formula results instead of formula in 2003 version?	Felicia Pickett	Excel Discussion (Misc queries)	2	September 14th 05 12:14 AM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
I want the results of a formula to show in cell, NOT THE FORMULA!	ocbecky	Excel Discussion (Misc queries)	4	December 10th 04 08:39 PM

All times are GMT +1. The time now is 05:25 PM.

Menu

About Us