Fix the Currency Symbol in an Excel VBA Number Format
Question details
Use VBA to display a fixed currency symbol in Excel cells across different regional settings.

- Product
- Microsoft Excel VBA
- Device & OS
- not provided
- Scenario
- A workbook uses a VBA number format to display monetary values on computers with different regional settings.
- Observed behavior
- A dollar sign used as a currency placeholder may display the local currency symbol instead of the intended U.S. dollar symbol.
Open the workbook in Excel and identify the cells that need the fixed currency format. Make sure the Developer tab is available so you can open the VBA editor and run the macro.
Apply a Locale-Tagged Currency Format with Excel VBA
Use a currency symbol and locale tag in the NumberFormat property to keep the intended symbol across regions.
In Excel, select Developer > Visual Basic, then choose Insert > Module.
Enter this code in the module: Sub SetUSCurrency() Range("A1").NumberFormat = "[$$-en-US]#,##0.00" End Sub. Replace A1 with the cell or range you want to format.
Return to Excel, select the target worksheet, and choose Developer > Macros. Select SetUSCurrency and click Run, then check that the cells display a dollar symbol.
To keep the VBA code, choose File > Save As and select Excel Macro-Enabled Workbook (*.xlsm).

Work with Currency-Formatted Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for everyday spreadsheet work. Its familiar interface and compatibility with Microsoft Office formats make it easy to move existing files into WPS Spreadsheets. The Excel VBA fix above must be applied in Excel.

Frequently Asked Questions
Why does my Excel VBA format show a different currency symbol?
A currency placeholder can follow the computer's regional settings. Set the cell's NumberFormat to "[$$-en-US]#,##0.00" to specify the U.S. dollar symbol and locale.
How do I apply the format to several cells?
In the VBA macro, replace Range("A1") with the desired range, such as Range("A1:A20"), and assign the same NumberFormat property.
Can I specify a euro symbol instead?
Yes. For example, use Range("A1").NumberFormat = "#,##0.00 [$€-de-DE]" to specify a euro symbol with a German locale tag.
Does changing the number format convert the currency value?
No. NumberFormat changes the displayed symbol and formatting, not the underlying value. Currency conversion requires a separate calculation and exchange rate.




