How to Format UPC in Excel

1. Open Microsoft Excel and load your spreadsheet.
2. Click on the triangle icon at the place where the row and column numbers converge. This icon selects all the cells in your worksheet for quick formatting. To highlight selected cells, hold Ctrl and click on each cell individually.
3. Click on the 'Home' tab near the top left corner of the spreadsheet.
4. Click the 'Dialog Box Launcher' icon next to the 'Number' group. This icon is represented by a small arrow.
5. Click 'Text' from within the 'Category' box. This reformats the cells to display numbers and letters exactly as inputted, without chopping off extra UPC code zeros.
6. Click 'OK' to save your changes. Your Excel cells are now properly formatted for UPCs.