Excel not calculating anything

[Sean Ooley]

Hello, I just installed excel 2003 and when I type in a function
(specifically, =CONCATENATE(A2," ",B2) ) It just adds that to the cell I'm
wanting the results in. It does this with sums as well. I am very novice
at excel, but I do know how do do the minor functions. Can anyone tell me
if there is some option I have unclicked or clicked that won't let excel
calculate anything?

Thank you

 

[Arvi Laanemets]

Hi

It looks like you have the calculation set to manual {press F9 to calculate
formulas manually, or check Automatic in radio button on Calculatin tab of
Options window (Tools.Options from menu)}
Or you have Formulas checkbox checked in View tab of Options window. When
this is the case, uncheck it.

 

[Gord Dibben]

Sean

In addition to Arvi's suggestion.

If all you see is the formula you typed, it is possible the "View Formulas"
option is set.

Hit CRTL + `(above TAB key) to toggle off/on.

Also possible your cells are formatted as text.

Re-format to General then F2 and <ENTER> on a cell.

If you have many of these to change, select all and Edit>Replace

what: =
with: =

Replace All.

Gord Dibben Excel MVP