Contents x
    When exporting Check ACH Information from FIMS incorrect ACH Account Numbers show when Opening Export File in Excel
    • 17 Feb 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    When exporting Check ACH Information from FIMS incorrect ACH Account Numbers show when Opening Export File in Excel

    • Updated on 17 Feb 2023
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    When exporting Check ACH Information form FIMS incorrect ACH account numbers show when Opening Export File in Excel.

    This occurs for account numbers that have 12 or more digits. The accounts appear in this format when viewed in Excel:
    Example, 3.50E+11

    Answer:

    This issue occurs when the text file is opened in Excel and then saved. Excel treats numbers that are 12 digits in length or longer as scientific so when the file is saved Excel truncates the insignificant digits.

    The solution is to highlight the column that contains the numbers where this issue occurs and change the format to General Format. After doing that ensure that no cell shows a value of E+11:

    Reset a number to the General format

    If the step above does not work, you can try the steps in the article below. Before opening, rename the *.csv to *.txt. When you open that the Text Wizard will pop up where you decide to import the numbers as text.

    Excel csv files converting long numbers to scientific notation


    Was this article helpful?
    What's Next