Hello Everyone,

I have a bit of a problem when I try to specify a number format for decimal numbers in angular. For example I want to set the decimal numbers to be shown with ',' as decimal separator in Excel, so I specify the following:

The gridCell.value is for example 0.04.
When exported in Excel I have the following for that cell - ,04000 and it has an applied Custom Number Format but this is the applied custom format -

Can someone point how can I resolve this?

PS. The issue that I want to resolve is that I have a specific Locale on frontend which can differ from the Machine Settings where the Excel file can be opened. The locale on the frontend also changes the decimal separator used in the grid I am trying to export, so I am trying somehow to unify on both places, no matter the region settings used.