| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions | |||
| Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
| formulas against columns not cells | Excel Worksheet Functions | |||
| In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
Linear Mode
