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

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
Sameer Saxena
Sameer Saxena Rank 1 - Community Starter
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

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

Answers