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.
***Edited by Moderator Marissa to update platform capability tags****
Thanks for your response. We have already invested lot of time to make OOTB Export Excel work. Hence we cannot move away from MSOGenerateExcelFile. I am sure there would be some formatting syntax within the activity without changing anything else. Earlier we were facing issue with the Date export. The date was exported in GMT. So We implemented something like this: