Re: I must be missing something...
I hate Excel it just breaks data by default.
Customer gets an EDI file does a small mod to a piece of text then saves.
Item codes with leading zeros, gone, long barcode numbers changed completely.
Importing prices for customer 016, does a tidy in Excel, now customer 16.
I use CSVED and Notepad++ as Excel will make me swear.
Finally NEVER open a DBF with it and save, it will not save in that format but completely change it.
I remember the telling off of the custoomer who did it and the trawls through backups.
Does almost as such damage as crypto worms.