ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Entering a function leaves the cell in text mode... (https://www.excelbanter.com/excel-discussion-misc-queries/203458-entering-function-leaves-cell-text-mode.html)

Kompu Kid

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)

Fred Smith[_4_]

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)




All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com