Reply to post: Re: Everything is potentially a US formatted date

Excel hell messes up ~20 per cent of genetic science papers

Omgwtfbbqtime
Windows

Re: Everything is potentially a US formatted date

I found the best way to deal with this was set your region to USian and leave it there. I don't get the mismatched date formats on the initial import (.CSV from a USian server) and once saved to .xlsx it keeps the dates the way they are meant to be for the other users.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon