Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - Can't see result
I have an Excel 2003 spreadsheet with a vlookup formula in it. I created it
using the formula bar and I can see the result in there, but I can only see the formula on the spreadsheet. I have tried to toggle the formula view (ctrl+`) and tested other functions (=2+2) to make sure they work...they do. Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - Can't see result
Format the cell as General (or anything but Text)
then select that cell, hit F2, then enter to make excel think you reentered the formula. plunk25 wrote: I have an Excel 2003 spreadsheet with a vlookup formula in it. I created it using the formula bar and I can see the result in there, but I can only see the formula on the spreadsheet. I have tried to toggle the formula view (ctrl+`) and tested other functions (=2+2) to make sure they work...they do. Any suggestions? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency to Text | Excel Worksheet Functions | |||
VBA | Excel Worksheet Functions | |||
spell number | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |