User Tools

Site Tools


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:

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
If you need to do this frequently, you may wish to create an Excel Macro.
reports/excel.txt · Last modified: 2019/03/29 14:19 by tmccanna