Re: An easy fix ...
You don't even need to do that. Just format the column as Text rather than general.
Yes yes, that works a treat if you are typing in data
Now try again with importing a multi megabyte CSV file full of, for example, phone numbers (leading zero gets stripped) or SIM numbers (truncated & converted to exponent notation).
It's relatively simple to write a pre-processor to put apostrophes into a CSV file to fix all that, but it should not be necessary.
Almost all Microsoft programs try to be helpful and in almost every case the "help" ends up creating more work than it saves.