Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Number in this cell is formatted as text or preceded by an apostrophe warning for data exported to E

Sameer SaxenaApr 17 2018 — edited Apr 17 2018

Problem:

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

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

pastedImage_1.jpg

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

Comments
Locked Post
New comments cannot be posted to this locked post.