Exporting To Excel Changes Number Format

(Doc ID 2169637.1)

Last updated on FEBRUARY 03, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.



When export an OBIEE analysis with custom data format, it shows incorrect dollar amounts in Excel.

1. Create a report with a couple of columns and a measure column with dollar amount.

2. Add a custom data format to the dollar amount column.
Data Format : $#,#,

3. Save the report and  export results to Excel.

4. Notice 9526 shows as $10


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