Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

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.

  1. Export from AccuZIP6 as a Text Tab Delimited file.
  2. Open that file in Excel.
  3. Highlight all fields and rows on the screen then right-click on the page to get a menu.
  4. Scroll down to Format Cells
  5. From the Number tab choose Text, and click OK.
  6. From the File menu, choose Save As and save the file in Excel format. 
  7. 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. 

« Back to Tech Notes

I just wanted to share how FABULOUS [Geoff] is and you should keep him for sure! I have had the best service and training from him in the last few days that it has sold me on keeping AccuZIP @ my new job. I was new to this software and learning in “trial by fire” mode and he got me thru it without any burns! He is amazing and deserves a raise, bonus, employee of year- SOMETHING BIG. I have dealt with the mail industry for about 30 years and never received this level of support and so positive. I am forever grateful and will suggest him and this product if asked. I am being very serious about his knowledge, skill, and interpersonal skill(hard to find these days).
K.P., Colorado Springs, CO