reports:excel
Formatting Long Numbers in Excel
Excel does not know how to handle the long numbers in PINES barcodes, and will shorten them in scientific notation:
To correct this:
- Right-click on the column header containing the barcodes.
- Choose Format Cells….
- Navigate to the Number tab.
- Change the Category to Number.
- Change the Decimal Places to 0.
- Click OK.
The barcodes will now appear correctly:
If you need to do this frequently, you may wish to create an Excel Macro.
reports/excel.txt · Last modified: 2023/10/23 17:34 by smorrison