Reply to post: Re: I must be missing something...

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

Charlie Clark Silver badge

Re: I must be missing something...

It's one of the reasons why so many scientists are switching to Python's Jupyter and Pandas, with Excel relegated to the format for reports.

Excel's import of text files has always been miserable, though this isn't helped by the deficiencies of the CSV format. But it really would be useful to be able to disable type inference as a preference and not fiddle with it, file by file.

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