Hi, I'm having trouble with how dates are formatted in my Excel (at least I think that's the issue).
I noticed it when I wanted to drag and fill down a column - I had a date 12.12.2012 written in the cell, when I drag down to fill it gave me
12.12.2012
12.12.2013
12.12.2014
12.12.2015
...
instead of
12.12.2012
13.12.2012
14.12.2012
15.12.2012
...
That is how it always used to fill for me, and now it doesn't anymore. I even tried the right-click drag, but it did the same and the options were all greyed out.
Then I noticed that my cell that contained 12.12.2012 wasn't recognized as Date, but as General so I switched to Locale (Slovenia), but it only changes that single cell to recognize that as a Date. And when I try to drag and fill (be it left- or right-click), it still changes the year, not the day of the date.
Does anyone know how to solve this? I want it always to fill changing days when i left-click drag.
Thanks
Bookmarks