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

Adrian 4 Silver badge

Re: I must be missing something...

I despise the auto data conversion (and many other autocorrect features that seem to get it wrong far more times than they get it right : I turn them off for a more productive experience).

But if you were regularly importing CSV into a spreadsheet, wouldn't you write a macro that set the column types first, then imported it ? And pass that macro around the community ?

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