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 ...
xlapp.Selection.NumberFormat = "$#,##0_);[Red]($#,##0)"
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