Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Excel shows my formula as text (Read 10245 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 43
Excel shows my formula as text
05.04.06 at 13:56:06
 
Sometimes Excel refuses to evaluate a formula and it displays the text of the formula instead. For example typing =Address(1,2) I would expect the cell to display the formula result B1 and not the formula text.
 
If Excel displays the formula text you need to reformat the cell first as general. Go to Format | Cell and specify the General number format.
 
Next you need to edit the formula once more. Press F2 to edit the cell and press Enter.  
Now Excel will have evaluated your formula and Excel will show the formula result.
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1