Formulas don't work

[Matthew]

I have a file in the 2003 Excel Professional edition in which th
formula on one column just shows the formulas only.
No matter what formula I put there, it just shows the formula. Yet whe
I e-mail the formula to another user using the older version, they jus
enter + in front of the equal sign and it works fine. Then when the
e-mail it back, I open the file and it works fine. But when I create
new fileor work on the one before, the formula won't calculate. I
happens to b
=CONCATENATE(+LEFT(+A3,2),".",+MID(+A3,3,4),".",+RIGHT(+A3,2)) but n
matter what formula, even +a2 and it won't work

 

[Dave Peterson]

Try selecting the problem column and do format|cell|Number tab|and choose
General (or some number type).

And then with that column still selected,
edit|replace
=
with
=

(it sounds like that column was formatted as text before you typed in the
formula).