reports:excel
This is an old revision of the document!
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:
reports/excel.1553883503.txt.gz · Last modified: 2019/03/29 18:18 by tmccanna