| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering a function leaves the cell in text mode...
Hello All:
Here is a new affliction in my excel spreadsheets: I enter a function, say, "=vlookup(A2,$A:$F,2)". Instead of displaying the result, the cell simply displays "=vlookup(A2,$A:$F,2)"! What is going on? Thanks, Deguza (Using Excel 2003 on XP) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering a function leaves the cell in text mode...
Your cell is formatted as text. Format it as general, then re-enter the
formula. Regards, Fred. "Kompu Kid" wrote in message ... Hello All: Here is a new affliction in my excel spreadsheets: I enter a function, say, "=vlookup(A2,$A:$F,2)". Instead of displaying the result, the cell simply displays "=vlookup(A2,$A:$F,2)"! What is going on? Thanks, Deguza (Using Excel 2003 on XP) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MODE function for text entries | Excel Worksheet Functions | |||
| Mode function in excel using Text | Excel Discussion (Misc queries) | |||
| Why do I get #### signs when entering cash amount in account mode | Excel Discussion (Misc queries) | |||
| Text to Columns leaves duplicate row of data at end | Excel Discussion (Misc queries) | |||
| Cancel of text box leaves sheet unprotected | Excel Worksheet Functions | |||
Linear Mode
