3 ms·
> 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
by eitland 7y ago
> 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 7y agoFormat your column prior to pasting data, paste special > match destination formatting
- MiracleUser 7y agothe 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