Reply to post: Re: It's even worse than that

Geneticists throw hands in the air, change gene naming rules to finally stop Microsoft Excel eating their data

Omgwtfbbqtime

Re: It's even worse than that

However, if you know that has happened, you can import the Excel abomination into something like Alteryx and run a formula on a column that contains string data to replace 44166 with DEC1 again, then output into a useful format.

After all - you do have the data specification for your inputs don't you? - Don't answer that...

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

SUBSCRIBE TO OUR WEEKLY TECH NEWSLETTER

Biting the hand that feeds IT © 1998–2020