asked on October 4, 2024
Hello,
I noticed that the currency format is not maintained in the exported excel. For example, if the flexmonster grid shows 48,523,389.00 in a cell, it changes to 4,85,23,389.00 in the exported excel. Is there a way to enforce a format and prevent it from changing when the grid is exported? I suspect Microsoft Excel is picking up the formatting based on some default but it would be great if I can prevent it by enforcing a format.
⋅ October 4, 2024
Hello, Amogh!
Thank you for writing to us.
As you mentioned, the issue with the number format in the exported Excel files is caused by regional formatting settings. Excel applies formatting based on the system locale, which can lead to differences in number representation. The format used in Flexmonster cannot be enforced for Excel, and you can only set it in Excel settings, as described in this guide: https://support.microsoft.com/en-us/office/change-the-character-used-to-separate-thousands-or-decimals-c093b545-71cb-4903-b205-aebb9837bd1e
Please let us know if this solution works for you.
Best Regards,
Maksym
