User Tools

Site Tools


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:

Scientific Notation

To correct this:

  1. Right-click on the column header containing the barcodes.
  2. Choose Format Cells…
  3. Navigate to the Number tab
  4. Change the Category to Number
  5. Change the Decimal Places to 0
  6. Click OK
Excel's Format Cells Dialog Box

The barcodes will now appear correctly:

[Corrected Barcodes

reports/excel.1553883503.txt.gz · Last modified: 2019/03/29 18:18 by tmccanna