Hello,
This may sound weird but I have a worksheet where the formulas in a few rows don't work while they work in others....no difference and no reason for this to happen.
In the past I have had to delete rows and read ........is there anyone who can shed light on this and fixes.....
One thing that has happened is my date format suddenly changed from dd-mm-yyyy to mm-dd-yyyy. I formatted it back but in the cell value bar at teh top it still shows mm-dd-yyyy.
The error is only happening in cells which show format as mm-dd-yyyy......which i see there are few ......
Not sure how this changed in the first place and why only a few cells changed and not all 2500 cells.
This may sound weird but I have a worksheet where the formulas in a few rows don't work while they work in others....no difference and no reason for this to happen.
In the past I have had to delete rows and read ........is there anyone who can shed light on this and fixes.....
One thing that has happened is my date format suddenly changed from dd-mm-yyyy to mm-dd-yyyy. I formatted it back but in the cell value bar at teh top it still shows mm-dd-yyyy.
The error is only happening in cells which show format as mm-dd-yyyy......which i see there are few ......
Not sure how this changed in the first place and why only a few cells changed and not all 2500 cells.
Last edited: