Formatting Issues

Fix Excel Currency Formatting Not Working on Cells

John Wilson Sep 29, 2026 879 views

Question details

Users are unable to apply the Currency format to specific cells in Excel, with the cells remaining in the General or Text format despite selection.

How to Fix Excel Currency Formatting Not Working on Cells

Product: Excel
Device & OS: not provided
Scenario: Applying currency formatting to numerical data for financial reporting, budgeting, or standard data entry.
Observed behavior: The Currency format is not applied to the selected cells, and the numerical values continue to display as text or in the General format.

Before you start

Verify that your worksheet is not protected and that you have the necessary permissions to edit cell formatting.

Solution 1Recommended

Convert Text Values to Numbers Using Text to Columns

This is the most effective method when numbers are accidentally stored as text, which is the primary reason currency formatting fails to apply.

When data is imported or pasted from other sources, numbers are frequently formatted as text. Excel cannot apply mathematical formatting like Currency to text strings.

Select the target cells

Highlight the specific column or range of cells where the currency formatting is not working.

Open the Text to Columns wizard

Navigate to the Data tab on the Excel ribbon and click the 'Text to Columns' button in the Data Tools group.

Convert to numbers

In the pop-up wizard, immediately click the 'Finish' button. This automatically converts the text strings into standard numerical values.

Apply currency format

Go to the Home tab, click the Number Format dropdown menu, and select 'Currency' to successfully apply the formatting.

Convert Text Values to Numbers Using Text to Columns

Quick Warning Indicator: If you see a small green triangle in the top-left corner of the cell, you can simply click it and select 'Convert to Number' instead of using Text to Columns.

Solution 2

Convert Values Using the VALUE Function

Use this method if you want to extract and convert text-formatted numbers into a new column without altering the original data source directly.

Solution 3

Clear Conditional Formatting Rules

Sometimes hidden rules or conditional formatting override manual formatting choices.

Effortless Spreadsheet Formatting

Apply Currency Formatting Seamlessly with WPS Office

WPS Office provides a highly compatible and intuitive spreadsheet application where formatting cells is fast and error-free. Easily convert text to numbers and apply your desired currency symbols without the usual formatting glitches.

1. Open your spreadsheet: Launch WPS Spreadsheet and open your document.
2. Use the smart indicator: Select the cells stored as text, click the yellow exclamation mark indicator that appears, and choose 'Convert to Number'.
3. Format instantly: Click the Currency symbol icon directly on the Home tab ribbon to apply flawless formatting.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats and formatting rules.One-click text-to-number conversion with intuitive, smart warning indicators.Lightweight software with a familiar interface for quick financial data formatting.Completely free to use for everyday spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my numbers have a small green triangle in the corner?

The green triangle is an error indicator showing that a number is currently stored as text. Clicking the warning icon gives you a quick option to 'Convert to Number', which will allow currency formatting to work.

Can regional settings affect my currency format in Excel?

Yes. If your computer's system regional settings are configured differently, the spreadsheet program may not recognize your input as a valid currency or may default to a foreign currency symbol. You can adjust this in your operating system's Control Panel or Settings.

How do I remove a custom format that's overriding my currency setting?

Select the affected cells, navigate to the Home tab, click the Number Format drop-down menu, and select 'General'. This clears the custom formatting, allowing you to freshly apply the Currency format.

Document & File Issues