E-PIA: The Last Zero After The Decimal Is Getting Stripped In Excel Sheet When Using Download Grid To Excel Functionality
(Doc ID 2781673.1)
Last updated on JUNE 08, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.
When using Download Grid to Excel, the last number zero is getting truncated after the decimal.
For example the data in Peoplesoft grid is 90.0 whereas in Excel it's showing as 90.
1. Have data in the Peoplesoft grid something like 90.0
2. Click on "Download to Excel" icon on the Grid.
3. Observe the Excel sheet.
4. The number shows as 90 instead of 90.0.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document