with all of the advanced features there are in Excel, I can't believe there isn't a UPC code format. Such a hassle. The rounding (which loses digits ) and changing to exponent format is constantly a hassle. There are some solutions provided online which don't seem to work reliably. I've literally probably lost hundreds of hours over my work years over this.