Re: Cannot calculate

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 11/13/04 

Date: Fri, 12 Nov 2004 21:50:14 -0500

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" <DavidLeeKH@gmail.com> wrote in message news:5afe26.0411121810.117523dc@posting.google.com...
> i found that some work*** cannot calculate the result and just
> showing the formula when i inputted it. Many thanks!
>
> rdgs
> David
Quantcast