USD Currency Format Regardless of Local Excel Version

[excel_2010]

Hello,

I'm creating a worksheet that will be used in various countries. I have a macro that converts local inputs into USD with the following code:

some_object.NumberFormat = "$0.0,,"

The problem is users with a UK specific version of Excel, for example, input in pounds and this code formats formats the number in pounds instead of dollars as it should. I assume it's because the $ in the format pulls the local default currency. Is there a way to override this in VBA so that the output always displays a dollar sign ($)?

Thank you for your help, and apologies if this topic has been covered; I didn't find it.

 

[jorismoerings]

Hi,


try changing your code to this: some_object.NumberFormat = "[$$]0.0,,"

Be aware: this will just override the currency sign but will NOT convert the local currency into a dollars!

 

[excel_2010]

This worked, thanks!