Cannot calculate

[DavidLeeHK]

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

rdgs
David

 

[routeram]

Hey,

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

Regards,
Ra

 

[David McRitchie]

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.