Fusion BIP: Non Numeric columns throw "The number in this cell is formatted as text or preceded by an apostrophe" error when report is exported as Excel
Last updated on NOVEMBER 04, 2016
Applies to:Oracle Fusion Financials Common Module - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
The issue can be reproduced at will with the following steps:
1] Create a Report online using the Report Editor, the Report should contain a Currency column
2] Save the Report
3] Run it Online
4] Select Export > Excel 2007+
5] Open the downloaded Excel, the currency column is of General Format and a notification near each cell says, "The number in this cell is formatted as text or preceded by an apostrophe."
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms