Why Is the Dollar Sign Not Working in Excel Formulas?

The dollar sign in Excel has two common jobs: it can display a number as currency, or it can lock a cell reference in a formula. If it is not working, first identify which job you mean: use a number format to show a currency symbol, or add dollar signs to a reference such as $A$1 to keep that reference fixed when copying a formula.

Two different meanings of the dollar sign

Excel does not treat every dollar sign as the same kind of instruction. In a value such as $25.00, the symbol is part of how the number is displayed. In a formula reference such as $A$1, it marks the column and row as absolute, so those parts of the address do not shift when the formula is copied. These uses are related only by the character itself.

This distinction explains many reports that the dollar sign “doesn’t work.” A user may type a dollar sign into a cell and expect a reusable currency format, when the cell now contains text. Or a user may format a number as currency but expect that setting to lock a formula reference. Currency formatting does not change formulas, and absolute references do not format values as money.

First decide what you expect to happen: should a cell display a currency symbol, should a formula keep pointing to one cell, or should both happen? The fixes are different, but each is straightforward once the purpose is clear.

Show a dollar sign as currency

For a numeric amount, select the cell or range and choose Home > Number, then select Currency or Accounting from the number format list. The Currency format places the symbol near the amount; Accounting aligns currency symbols and decimal points within a column. Both leave the underlying value numeric, so Excel can still add, subtract, and calculate with it.

You can also open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, and select Currency or Accounting. On Mac, Command+1 opens Format Cells. In Excel for the web, use the number-format controls on the Home tab; the exact compact layout can vary with the browser window. If the default symbol is not the one you want, choose a suitable symbol in the format options where available. Excel may use regional settings to determine the default currency and decimal conventions.

For example, if a cell contains the numeric value 25.5, applying a two-decimal currency format can display it as $25.50. The displayed zeros and symbol do not mean the stored number has changed. If another workbook or system uses a different regional setting, the same number might display with a different currency symbol or decimal separator.

If typing a dollar sign directly seems to work inconsistently, enter the number without the symbol and apply a number format afterward. Excel often recognizes a currency symbol typed with a number, but recognition depends on the cell’s existing format and regional conventions. A value imported from a text file may also contain a symbol as literal text rather than as a numeric currency value.

Lock a formula reference with dollar signs

In a cell reference, the dollar sign fixes whichever part follows it. A1 is relative: copying the formula can change both the column and row. $A$1 is absolute: neither changes. $A1 fixes the column but allows the row to change, while A$1 fixes the row but allows the column to change. These mixed references are useful when copying formulas across a table.

For example, imagine product prices are in B2:B4 and a tax rate of 8% is in F1. With prices of $25, $40, and $10 in B2:B4, a formula in C2 can calculate the tax amount using the fixed rate. With that layout, enter =B2*$F$1 in C2; the result is 2 when B2 is 25. Copying the formula down changes B2 to B3 and then B4, while $F$1 stays fixed. The calculated tax amounts are 2, 3.2, and 0.8.

When a reference is not locked, copying a formula one row down normally changes its row number. That behavior is usually correct for a list of prices, but it is a problem when every row must use the same rate, exchange-rate input, or commission percentage. Add the dollar signs to the fixed reference rather than changing the number format.

Use F4 to add or cycle the reference locks

While editing a formula in Excel for Microsoft 365 on Windows, place the insertion point on a cell reference and press F4. Excel cycles through the reference styles: A1, $A$1, A$1, and $A1. Stop when the reference has the combination you need. You can also type the dollar signs yourself.

On some Windows laptops, the function-key row controls brightness or volume, so you may need Fn+F4 instead. On Mac, Command+T is the usual shortcut for cycling reference styles while editing a formula; depending on the keyboard, you may need to use the function-key setting or Fn with the relevant key. If a shortcut does not respond, check that the formula is being edited and that the cursor is on the reference, rather than merely selecting the cell.

F4 has other uses in Excel depending on what you are doing. For reference locking, it works in the context of editing a formula. Pressing it after leaving formula-edit mode will not necessarily change the selected cell’s reference. In Excel for the web, keyboard behavior can depend on browser shortcuts and keyboard settings; typing the dollar signs directly is a reliable alternative.

Why a typed dollar sign may turn into text

If Excel will not calculate with a value that appears to include a dollar sign, the cell may contain text. Common clues include a green error indicator, left alignment when neighboring numbers are right-aligned, or formulas that ignore the entry in a sum. Alignment is only a clue, not proof, because users can manually align numeric cells.

The cell is formatted as Text. Change the format to General or an appropriate number format, then re-enter the value. Changing the format alone may not convert a value already stored as text.
The entry begins with an apostrophe. An apostrophe forces Excel to treat the following characters as text. Remove it if the cell should hold a number.
The symbol or separators do not match regional settings. A pasted amount using a different decimal or thousands separator may not be parsed as a number.
The value came from an import. Imported data may preserve currency symbols and spaces as characters. Use the import or conversion tools appropriate to the source, and verify that the result is numeric before relying on calculations.

A practical check is to select the cell and look at the formula bar and number format. If the entry is text, applying Currency may not turn it into a usable number. Re-entering the amount as a number and applying the desired format is often simplest for a small range. For a large imported range, use a deliberate conversion process and compare a few results against the source.

Why dollar signs disappear or move after copying

If you mean formula references, the sign may be missing because the reference was never made absolute, or because F4 was pressed with the cursor somewhere else in the formula. Edit the formula, click or move the insertion point into the address, and cycle the reference type. Check the formula in the destination cell after copying; the formula bar shows whether it still points to the intended input.

If you mean the displayed currency symbol, copying a cell can also copy its formatting, replace the destination’s existing format, or leave the symbol behind depending on the paste operation. Use Paste Special options such as Values when you want the result without copying the source formatting, or apply the desired format to the destination afterward. If only some cells show a symbol, inspect their number formats rather than assuming the values differ.

Custom number formats can also make a symbol appear unexpected or disappear. Select the cell, open Format Cells, and inspect the Number category. Choosing Currency or Accounting resets the display to a standard built-in format. If the workbook uses a custom format, the visible symbol may be specified by that format rather than being part of the cell’s value.

Currency format versus absolute references

These features solve separate problems, so use the one that matches your goal. To show money, format the cell as Currency or Accounting. To keep a reference fixed while filling a formula, use an absolute reference. A worksheet can require both: a formula may calculate a monetary result using a fixed rate, and the result cells can then be formatted as currency.

It is also useful to distinguish a currency symbol from the currency itself. A dollar sign does not say whether an amount is US dollars, Canadian dollars, Australian dollars, or another currency that uses the same symbol. If the workbook will be shared, label the currency clearly in a heading or use an appropriate regional symbol and descriptive text. Formatting affects appearance; it does not convert one currency into another or apply an exchange rate.

Likewise, an absolute reference does not freeze the value in the referenced cell. If F1 contains 8%, then $F$1 keeps pointing to F1 when copied. If someone changes F1 to 9%, formulas referring to it will generally calculate using the new rate. The dollar signs lock the address, not the contents.

A quick troubleshooting sequence

When the dollar sign is not behaving as expected, work through these checks in order. This avoids changing unrelated workbook settings when the issue is only a mismatch between formatting and formula references.

Ask whether the problem is about how a number looks or which cell a formula uses.
For appearance, select the cell and apply Currency or Accounting from the Home tab’s number-format controls.
For a formula, edit it and confirm that the intended reference has the needed dollar signs. Use F4 on Windows or Command+T on Mac while editing, if the shortcut is available.
If a displayed amount will not calculate, check whether the cell is Text or whether the imported value contains literal characters.
Copy the formula or format to a test cell and inspect the result before filling a large range or changing many cells.

These checks also help separate a formatting issue from a calculation issue. Excel’s calculation mode affects when formulas recalculate, but it does not determine whether a dollar sign locks a reference or whether a number format displays a currency symbol. If the formula points to the right cell but the answer seems stale, check calculation settings separately.

Frequently Asked Questions

How do I put a dollar sign in front of every number in Excel?
Select the cells and choose Currency or Accounting from the number-format list on the Home tab. This changes how numeric values display without requiring you to type a symbol into every cell.

How do I make a cell reference stay the same when I drag a formula?
Edit the formula, select or place the cursor on the reference, and use F4 on Windows to cycle its lock style. For a fully fixed reference, use a form such as $A$1. On Mac, Command+T is the usual reference-style shortcut.

Why does Excel show the dollar sign but not add the amount?
The apparent amount may be text rather than a number, particularly if the cell is formatted as Text or the value was pasted from an external source. Convert or re-enter it as a numeric value, then apply Currency formatting and verify that calculations include it.

Does the dollar sign in a formula make the value permanent?
No. It locks the row, column, or both in the cell address when a formula is copied. The contents of that referenced cell can still change, and dependent formulas can update when they recalculate.

Why does my dollar sign change to another currency symbol?
Excel’s currency display can depend on the selected number format and regional settings. Choose the intended symbol in the format options where available, and label the currency clearly if the workbook will be used across regions.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.