Reply to post: Re: Backend bod: "Either way is fine"

Software changed the world, then died on the first of the month

J.G.Harston Silver badge

Re: Backend bod: "Either way is fine"

Excel goes out of its way to try and interpret anything as a date.

"11/12","High Street" becomes "11-Dec","High Street"

And if that wasn't bad enough, it will try and translate strings into numbers

"12E2" because "1200"

"01709" becomes "1709"

"123456789012345" becomes "12345678901E4"

"-" becomes "-0" !!!!

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