Unable to change formula in excel sheet

[jabwylie]

I have following formula in sheet COUNTA(D6:D28), it works beautifully, the whole sheet is protected as it's for my boss and he's prone to bugger things up.

I need to change the range to finish on D27 now, easy peasy, I thought.

I unprotected the sheet, and changed the value.................it wont work.

The formula is displayed in the cell instead of the answer??

The answer is used in another sheet, but I even tried copying the sheet to a new workbook and changing the formula to no avail. I'm sure it must be something stupid, but I am a fafirly competent excel user and have never been unable to change a formula in a sheet???

Help please.

Ps , I cannot change ANY of the formulas in the sheet not just this one

 

[jabwylie]

just_jon

Thou art truly a star................changed to general and it worked a treat.

NOW,

could you tell me why?

thanks for all your help

 

[jabwylie]

PS

although I changed a column of cells to general, when I paste a formula there (from a general cell) the format changes to text, so I have to change each individual cell back to general and then reconfirm formula.

Is there any way I can stop this format change on pasting?