Question
Texas Commission On Environmental Quality
US
Last activity: 21 Sep 2018 14:11 EDT
Export to Excel - Currency Format (Pega 7.1.8)
Hello,
Hope everybody is doing well. My requirement is to export data to excel. The problem is occuring in exporting currency value where excel just displays decimal values instead of displaying into currency format. i.e Excel displays 2000.00 instead of $2,000. It should export the data it displays on the front-end
I am attaching screenshots for your reference. The amount property is defined as Decimal in pega and formatted as Currency while displaying.
Thanks in advance for your help.
Regards,
Arpan Parikh
***Edited by Moderator Marissa to update platform capability tags****