Cannot calculate
 

i found that some worksheet cannot calculate the result and just
showing the formula when i inputted it. Many thanks!

rdgs
David

Cannot calculate
 

Hey,

Did you type a "=" before your formula?(!) Can you elaborate a littl
more on your problem. What formula did you enter?

Regards,
Ra

--
routera
-----------------------------------------------------------------------
routeram's Profile: http://www.excelforum.com/member.php...fo&userid=1045
View this thread: http://www.excelforum.com/showthread.php?threadid=27793

Cannot calculate
 

Make sure you have not turned off calculation:
Tools, Options, Calculation (tab), [x] automatic
(the shortcut Ctrl+` the key to left of number row is a toggle)

Make sure you haven't made the format text, see what you have
if you select formula cell and use Format, Cells, ...look...

In another column enter =A1 does that work
it would show that formulas work or don't work,

if it works possibly you have extra characters like a space
before the equal sign or other characters that look like spaces.
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

Would you tell us what the problem actually was, I expect it will
be one of the above.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DavidLeeHK" wrote in message ...
i found that some worksheet cannot calculate the result and just
showing the formula when i inputted it. Many thanks!

rdgs
David