locked
export to excel problem RRS feed

  • Question

  • Hi,

    I have a matrix report to build which has a field that contains both integers and string. when this report is exported to excel, the integers come with a green traingle reading number stored as text.

    I have tried using cstr, cchar, format....

    Nothing seem to work.

    Thanks
    Wednesday, October 21, 2009 2:52 PM

Answers

  • Is this just purely cosmetic?  This by nature is just Excel trying to warn you that you have data in a cell which might have been assigned the incorrect format (data type).

    If you want a work around for this...you could export the data to a CSV, open Excel and make sure to set the entire column where you are seeing this issue to text before you import the data (for example if it is the 4th column set Column D to text), and lastly import the CSV and make sure to set the problem column to the text data type.

    This adds a couple extra steps but if you want to get rid of those green triangles this is the only way that I have found.

    Let me know if this helps at all!
    Check out my blog!
    • Proposed as answer by Jerry Nee Friday, October 23, 2009 8:43 AM
    • Marked as answer by Jerry Nee Friday, October 30, 2009 5:56 AM
    Wednesday, October 21, 2009 3:02 PM