Correct formulas in cells, have to retype to work
 

At work we have a worksheet that was used for all of 2004. Formulas worked
fine. At the beginning of the year we made a new worksheet from 2004 and
called it 2005. Lately when we put numbers in the cells are not adding up.
Example...cell reads =p64+s+64. So the formulas is correct but for some
reason it is performing the way it should. If I re-enter the formula then it
is fine but I do not want to have to redo all of the page. Any suggestions

Is calculation set to manual? Try Tools / options / Calculation - change to
automatic

Does hitting F2 and then enter on any of these cells do it? if so then just
select the whole sheet, do Edit / Replace / Replace what = '=', replace with
= '='. Don't actually put the quotes in, and yes I am suggesting you
replace = with =. Try it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"budsb1" wrote in message
...
At work we have a worksheet that was used for all of 2004. Formulas
worked
fine. At the beginning of the year we made a new worksheet from 2004 and
called it 2005. Lately when we put numbers in the cells are not adding
up.
Example...cell reads =p64+s+64. So the formulas is correct but for some
reason it is performing the way it should. If I re-enter the formula then
it
is fine but I do not want to have to redo all of the page. Any
suggestions

thank you so much. After I posted I went in to the excel training and looked
around. Now will try it first thing next week. Thanks again

"Ken Wright" wrote:

Is calculation set to manual? Try Tools / options / Calculation - change to
automatic

Does hitting F2 and then enter on any of these cells do it? if so then just
select the whole sheet, do Edit / Replace / Replace what = '=', replace with
= '='. Don't actually put the quotes in, and yes I am suggesting you
replace = with =. Try it.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"budsb1" wrote in message
...
At work we have a worksheet that was used for all of 2004. Formulas
worked
fine. At the beginning of the year we made a new worksheet from 2004 and
called it 2005. Lately when we put numbers in the cells are not adding
up.
Example...cell reads =p64+s+64. So the formulas is correct but for some
reason it is performing the way it should. If I re-enter the formula then
it
is fine but I do not want to have to redo all of the page. Any
suggestions

Just post back if it doesn't work, but i would hope that one of those gets
you sorted :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
<snip