1 Reply Latest reply on Apr 17, 2018 11:29 AM by Michael Verzijl

    Number in this cell is formatted as text or preceded by an apostrophe warning for data exported to Excel from OBIEE 11.1.1.7.150120

    Sameer Saxena

      Problem:

      When report data is exported to excel 2007+ format , while opening it shows 1st warning message as

      If we click on  "Yes" then file open up and shows 2nd warning message as

      Data is exported correctly for all the columns except for few number datatype and green triangle is added to each cell of those columns indicating some warning sign as

      "The number in this cell is formatted as text or preceded by an apostrophe"

       

      Regards,

      Rani