Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
BIP report Excel output is formatting large numbers as General/scientific — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP report Excel output is formatting large numbers as General/scientific

Accepted answer
21
Views
5
Comments

Summary:

We created a BIP report for Fixed Assets. Any numerical values in the tens of millions or higher export to Excel as scientific. For example, an asset Cost of 42,482,278.51 shows as 4.248227851E7 in Excel. All the cells are formatted as "General", which is the root cause I guess.

Any way to have the report format certain columns as Number before exporting the results to Excel?

Thanks!

Content (required):


Version (include the version you are using, if applicable):


Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!