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: 2023/10/23 17:34 by smorrison