View IMB Digits in Excel
If you open either a CSV or Microsoft Excel export from AccuZIP6 in Excel to view the IMBdigits, and the numbers appear in this sort of format - 3.11902517535015E+28 or 3.11903E+28, the view issue is being caused by Excel.
In Microsoft Excel, large and small numbers are stored automatically in Scientific Notation by default. Excel has a number limit which is 15 digits. Since the contents of the imbdigits field is up to 31 digits, Excel automatically converts that to scientific notation as a way of dealing with that limit. You can easily remove scientific notation in Excel by following the steps below.
- Export from AccuZIP6 as a Text Tab Delimited file.
- Open that file in Excel.
- Highlight all fields and rows on the screen then right-click on the page to get a menu.
- Scroll down to Format Cells.
- From the Number tab choose Text, and click OK.
- From the File menu, choose Save As and save the file in Excel format.
- Open the new file in Excel.
You should be able to view the IMBdigits properly as numbers and not a Scientific Notation.
You can also open a .CSV export in Note Pad and view the IMBdigits as numbers.
