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
26
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!