Export numbers in a different format

[Brett_WP]

Hi all, wondering if this is possible?

I have a table, where the Sales amounts are in Millions i.e... $1,457,900 in Sales  and formatted to  $1.46 in my Qlik table.

When I export this table, is it possible to export the full Sales figures without manually adjusting in Excel?

i.e. My Qlik table shows $1.46579 using expression: = Sales_Amt/1000000    with format pattern:    $#,##0.00

I want my export to show $1,457,900 and NOT $1.46579 however I want to keep the abbreviated format in Qlik.

Can this be done?

Thanks in advance!