[eitland]

> The only advantage of Libre office is the price, which is a non-factor for any major corp.

Another one: Excels stubborn insistence on mangling anything that can be somehow construed into a date into one :-/

[soared]

Format your column prior to pasting data, paste special > match destination formatting

[MiracleUser]

the most solid way to handle it is to use data import from text file (handles csv) so you can configure the columns while looking at them

Which recent excel versions you can bring that data table directly into power query as well, which is useful if youve got multiple csv you are trying to look at that are related