VBA & Macro Problems

Fix the Currency Symbol in an Excel VBA Number Format

Bushra ParveenBushra Parveen Nov 22, 2026 868 views

Question details

Use VBA to display a fixed currency symbol in Excel cells across different regional settings.

Use a Fixed Currency Symbol in an Excel VBA Number Format
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the VBA editor

In Excel, select Developer > Visual Basic, then choose Insert > Module.

2
Add the currency format macro

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.

3
Run and check the macro

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.

4
Save the macro

To keep the VBA code, choose File > Save As and select Excel Macro-Enabled Workbook (*.xlsm).

Apply a Locale-Tagged Currency Format with Excel VBA
Formatting does not convert currency: The number format changes how a value is displayed; it does not convert the amount between currencies. Decimal and thousands separators may still reflect regional settings.
Free Microsoft Office alternative

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.

Format monetary values in spreadsheets with currency options.Open and edit common Excel formats, including XLSX and XLS.Use a familiar spreadsheet interface for an easier transition from Microsoft Office.Work with a lightweight office suite available for free.
microsoft office alternative - wps office

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.