Finance | Project Operations, Human Resources, ...

how to add currency symbol with amount during excel export?

(0) Share

Report

Posted on by @rp@n

Hi all,

Can you please let me know, how to add currency symbol with amount during excel export?

Please give me more shed on this

Thanks!

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Good morning @rp@n,

Can't you simply do the currency formatting with the symbol in Excel directly?

Trying to do that through AX might not be easy as you might have different companies that use different currencies and symbols, etc.

Also thing about non-finance amount related Excel exports that just export numbers.

In Excel, it takes a couple of seconds doing the formatting...

Best regards,

Ludwig

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

thanks Ludwig

as you said

"Trying to do that through AX might not be easy as you might have different companies that use different currencies and symbols, etc."

can i put legal entity validation during get currency symbol? it will work?

because customer wants currency symbol with amount

please give me more shed on this.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi @rp@n,

I think that the legal entity validation is not sufficient.

Imagine that users export inventory data, do you want to have a $, EUR or other currency symbol when exporting those data to Excel?

To overcome those issues, you would need additional checks on the nature of the data that is exported.

I assume that this can quickly get quite complex because you can export almost everything to Excel.

My recommendation would be not doing that and use Excel instead.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

you can customize a display method to retrieve the currency symbol to your form.

if this form is a grid and allowed to export. you can export the amount and symbol easily

Was this reply helpful? Yes No
@rp@n 30 on at

Like (0)

Report

hi hakim,

i wrote excel code for exporting. i need currency symbol with amount

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Arpan,

Is it about the currency symbol or the currency (ISO) code? If you want to format the Excel amount column, it would be hard if there are multiple currencies involved. Most companies in the world do use two columns: Currency and Amount. Then they also know what can be summed up in Excel or not.

Was this reply helpful? Yes No