How to retain money format while exporting data to excel?

[Anonymous]

Hi All,

I have a chart with Sales amount in y axis. But the format of the amount i have defined using num() there.

I need to get the same format in the excel sheet when it is exported.

Any help on this would be appreciated.

Thanks in advance

[Anonymous]

If the number format is defined on the properties panel, it should carry over when exported to excel.

[Anonymous · Accepted solution]

The solution is to use Money() instead of num()