It's time for a UPC format
Excel dev team. I love this product, and always have, but please, for the love of all that is holy, create a native UPC format for Excel.
I have never, a single time, in the 25 years I have been using this product used Scientific Notation as a format, ever. For anything.
Yet the amount of time I've wasted chasing down and re-formatting the columns containing UPC or EAN numbers to number, (no, 0 decimal places thank you) is as uncountable as the number of times I've used Scientific Notation is countable.
Please. It's time.
Detecting 13/14 character EAN codes when opening CSV files and formatting them correctly would me so many headaches.