Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 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
    ------------------------------



  • 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