Version: 21.106.0024
We use “No Rounding” for rounding and “#,##0” as formatting to display whole dollar amount on the report and but need 2 decimal when export to Excel for analysis.
This works fine in 20R1 version, but 21R1, only whole number got exported to Excel, seems formatting actually truncated the decimals.
Best answer by woodyg84
only solution is changing the format to #,##0.00 that will show whole number on report but can show decimal in Excel by changing the format. not clean solution at allthough
only solution is changing the format to #,##0.00 that will show whole number on report but can show decimal in Excel by changing the format. not clean solution at allthough
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
