Data360 Analyze

 View Only

  • 1.  Number Stored as Text Error in Inserting Data in Excel

    Posted 10-09-2023 10:19

    I have list of data that needs to be inserted on an excel file. Some of the columns are number, I already handle the conversion to type long of this columns, but when the data was inserted on the excel file I'm getting the error "Number stored as Text" on. Do we have fix for this?

    Appreciate your help. 😊



    ------------------------------
    clef andrin
    Knowledge Community Shared Account
    ------------------------------


  • 2.  RE: Number Stored as Text Error in Inserting Data in Excel

    Employee
    Posted 10-10-2023 10:14

    When loading Excel, the int and long datatypes do get converted to text.  You'll need to make those into double types if you want them to appear in Excel as numbers.



    ------------------------------
    Ernest Jones
    Precisely Software Inc.
    PEARL RIVER NY
    ------------------------------

    Original Message


  • 3.  RE: Number Stored as Text Error in Inserting Data in Excel

    Posted 10-10-2023 12:42

    Thank you very much. It works now. Appreciate the help.



    ------------------------------
    clef andrin
    Knowledge Community Shared Account
    ------------------------------

    Original Message