Hi,
I have a formula in a cell which will not drag corectly down the column. It is reproducing the value calculated by the 1st row formula into the other rpws of the column.
The column was set to "General" format before creating the formula and all cells were cleansed by highlighting and pressing the delete key before entering the formula.
It is happening all over the worksheet when I try to create columns using formulae so I think there is some global setting that is causing the issue.
I was sent the file and did not create it myself so I do not know what settings could be creating the problem.
Any help most appreciated.
Rgds
I have a formula in a cell which will not drag corectly down the column. It is reproducing the value calculated by the 1st row formula into the other rpws of the column.
The column was set to "General" format before creating the formula and all cells were cleansed by highlighting and pressing the delete key before entering the formula.
It is happening all over the worksheet when I try to create columns using formulae so I think there is some global setting that is causing the issue.
I was sent the file and did not create it myself so I do not know what settings could be creating the problem.
Any help most appreciated.
Rgds
