hi guys, first post.
I`m having a problem with Excel date formatting which is really quite bizarre.
All of a sudden, on random dates, it has started to switch the month with the day, so if I enter 10/06/2007 it will switch it to 06/10/2007. This does not happen on every instance of this particular date or even on every date you enter, just seemingly random ones. It will also not switch it if the day that you enter is greater than 12, so 15/06/2007 will be left alone.
This has just started happening and I can't figure out why. One of my colleagues says she has encountered this problem before and resolved it by copying and pasting all of the data into a fresh Excel workbook and saving, which did work on the day I did it but it is continuing to do this.
I have never encountered this problem before but I have not previously been a heavy user of any MS Office products.
The cell is formatted as a date of type *14/03/2001. I have tried it as just 14/03/2001 but it doesn't make any difference. Apparently, the * means that it will not switch date orders with the operating system. The OS is set to UK dates.
I`d appreciate any help as I have just started my job and am trying to impress by reformatting all their Excel logs to be a bit more readable, this one is making me look a bit of a twit!
Bookmarks