Currency Format, written in US run in Shanghai

Hi All.

I have an access db that creates / populates excel and then formats the report. I have currency that is in USD so I format it as ...

Please Login or Register  to view this content.

when I run in the US, I get what I expect "$100,000", but when this application is run in Shanghai, they get...

Capture.JPG

and of course, the actual values are the same if run in US of Shanghai.

How so I get it to show USD when run from Shanghai?

Thanks
Steve
Harrisburg, PA

SOLVED!!! It took a couple hours searching and piecing stuff together... This is the solution: In excel, when you format a cell currency, In my case on my computer $, it really is not dollars - Assuming that you choose the first selection below the "NONE" in the dropdown box...

Capture.JPG

vba = Selection.NumberFormat = "$#,##0.00"

The first selection below "NONE" is the regional setting for the currency. So, if I run VBA on my computer in the US and choose "$" (1st selection below the NONE), I will see USD. But, if my VBA runs on a computer in Shanghai, it will set the symbol to their local currency, not $. So, to get the VBA to format the cell properly, I must choose (see below)

Capture2.JPG

recording a macro, this will be:
Selection.NumberFormat = "[$$-409]#,##0.00"

Thanks!
Steve
Harrisburg, PA