Dollar Sign Not Working in Excel? Fix Common Causes

If the dollar sign is missing in Excel, first check what you mean: press Shift+4 on a US keyboard to type the character, choose Home > Number > Number Format > Currency to display a currency symbol, or select a cell reference inside a formula and press F4 to make it absolute. These actions solve different problems, so the right fix depends on whether you are entering a symbol, formatting a value, or locking a reference.

Identify Which Dollar Sign Is Missing

Excel uses the dollar sign in two distinct ways. It can be a visible character in a cell, such as part of a label or a price, or it can be part of a cell reference in a formula. In a reference such as $A$1, the dollar signs tell Excel to keep the column and row fixed when you copy the formula. They do not add a currency symbol to the value.

Currency formatting is a third, separate issue. A cell may contain the number 25 while Excel displays it as $25.00 because of its number format. The underlying value remains 25; the symbol is part of how the value is shown. If a cell displays 25 instead of $25.00, change its number format. If you need a literal dollar character as text, type it directly. If a formula changes references as you copy it, use an absolute or mixed reference.

Type a Dollar Sign in a Cell

On a standard US keyboard, hold Shift and press 4. In Excel, click the cell and type the dollar sign along with any other text, then press Enter. For example, typing $ budget stores text, not a numeric amount that Excel can reliably use for arithmetic. If you want to calculate with the amount, enter the number alone and apply currency formatting afterward.

Keyboard layouts vary. If Shift+4 produces another character, check the active keyboard layout or use the operating system’s on-screen keyboard to locate the dollar sign. Excel does not normally require a special setting to type it, and pressing F4 is not a way to insert a dollar sign as text. F4 changes a cell reference only while you are editing a formula.

If the character appears briefly but is replaced, check whether you are typing into a cell that has a data-entry restriction, such as a validation rule, or whether another program or keyboard utility is intercepting the key. Try typing in a blank cell in a new workbook. If it works there but not in the original file, inspect the cell’s validation settings and any workbook-specific protections.

Show a Dollar Sign with Currency Formatting

To display a numeric amount with a currency symbol, select the cells and use Home > Number > Number Format > Currency. You can also open the Format Cells dialog with Ctrl+1 on Windows, choose the Number tab, and select Currency. Choose the symbol, decimal places, and negative-number style you need. The available currency symbols and default choices can depend on your regional settings.

Accounting is another number format, not a different way to enter a dollar sign. It aligns currency symbols along the left side of the cells and values along the right, which can make a column of financial figures easier to scan. Currency places the symbol closer to each number. Choose the display that suits the worksheet; both formats keep numeric values available for calculations.

If you select a currency format and still do not see a symbol, check that you selected the intended cells and that the format is not being overridden by a custom number format. Open Format Cells and inspect the Number format. Also check the column width: a narrow column may show #### instead of the formatted amount. Widen the column by dragging the boundary between its column headings, or double-click that boundary to fit the contents.

On Excel for Mac, use the Home tab’s number-format controls or open Format Cells from the Format menu; the exact placement can vary with the ribbon layout. The currency-format shortcut on Windows is Ctrl+Shift+$, though keyboard layout can affect how you enter the key combination. On Mac, Control+Shift+$ is commonly used; if a system or keyboard setting intercepts it, use the ribbon or Format Cells instead. Excel for the web also provides number-format controls on the Home tab, though the desktop Format Cells dialog and some options may differ.

Use F4 to Lock a Formula Reference

When a dollar sign is missing from a formula reference, the issue is usually that the reference is relative. Excel normally adjusts a reference when you copy a formula to another cell. A dollar sign fixes the column, the row, or both. For example, $A$1 fixes both; $A1 fixes the column only; A$1 fixes the row only; and A1 fixes neither.

With a quantity in B2 and a fixed unit price of 12 in E1, enter this formula in C2: =B2*$E$1. If B2 contains 3, the result is 36. When you copy the formula down, B2 can change to B3, B4, and so on, while $E$1 remains fixed. This is useful for applying one tax rate, exchange rate, discount, or other constant to several rows.

To add the dollar signs with the keyboard, edit the formula, select or place the insertion point in the cell reference, and press F4. Each press cycles through relative, fully absolute, and mixed-reference forms. On Windows laptops, you may need Fn+F4 if the function-key row is assigned to hardware controls. On Mac keyboards, try Fn+F4 if the function keys are set to control system features; otherwise try F4. You can always type the dollar signs directly into the reference.

F4 works in this context only while the formula is being edited and a reference is selected or active. If you press it while a cell is merely selected, Excel may repeat the last action instead of changing a reference. Click in the formula bar or press F2 to edit the cell, move to the reference, and then try again. In Excel for the web, editing the reference manually is a dependable alternative if the browser or keyboard intercepts the shortcut.

Check Whether the Cell Is Formatted as Text

A cell formatted as Text can make Excel treat what you type as text rather than as a number or formula. This can make currency formatting appear ineffective, because a text value is not a numeric value that can be displayed using a currency number format. A leading apostrophe can also force an entry to be treated as text; the apostrophe may not be visible in the cell itself.

For a simple fix, select the affected cell, set its format to General or the desired number format, then edit the entry and press Enter so Excel reinterprets it. Changing the format alone may not convert a value that Excel has already stored as text. If Excel shows a warning indicator, its Convert to Number option may be available. For a large imported column, inspect a few values first: spaces, nonbreaking spaces, or symbols included in the source data can prevent conversion and may require cleaning the source.

After conversion, apply Currency or Accounting formatting if you want the dollar sign to appear. Avoid adding a dollar sign to every stored value merely to make it look like money. Keeping amounts numeric makes sorting, summing, and other calculations more reliable.

Check Formula Display and Workbook Settings

If you see the formula text instead of a calculated amount, the problem may not be the dollar sign. The worksheet may be showing formulas, or the cell may be formatted as Text. On Windows, Ctrl+` toggles Show Formulas; the grave accent is usually the key near the upper-left corner of the keyboard. You can also check Formulas > Formula Auditing > Show Formulas. Turn the setting off to return to calculated results.

If only one cell shows a formula literally, change its format from Text to General, edit the formula, and press Enter. If formulas display but their results do not update, check Formulas > Calculation Options and confirm the workbook is set to Automatic unless manual calculation is intentional. These settings affect calculation or display, not whether the dollar symbol is a valid character.

Diagnose Common Dollar-Sign Problems

You see a number but no currency symbol: Apply Currency or Accounting formatting and confirm the selected cells are numeric.
You see ####: Widen the column. Excel may not have enough space to show the formatted value.
The formula changes the reference when copied: Lock the needed row or column with dollar signs, using F4 while editing the reference or typing them manually.
F4 does nothing: Make sure you are editing a formula and have the reference active. Try Fn+F4 on a laptop or Mac keyboard.
A dollar sign appears in the cell but calculations fail: The entry may be text. Store the amount as a number and apply currency formatting separately.

For a quick diagnosis, test the same action in a blank cell. Type a number and apply Currency; then enter a simple formula and use F4 on one of its references. If these work in a new workbook, the original sheet likely has a cell format, validation rule, protection setting, or imported text value affecting the result. If they fail everywhere, check the keyboard layout, function-key settings, or Excel’s ribbon controls.

Choose Between a Symbol, a Format, and a Reference

Use a literal dollar sign when it is part of text, such as a heading or a note that will not be used in arithmetic. Use Currency or Accounting formatting for amounts that should remain numeric. Use dollar signs inside a formula reference when copying that formula must keep a row, column, or cell fixed. These choices can look similar on screen but behave differently.

For example, typing $25 as text may look right but can cause problems when you total a list of entries. Entering 25 as a number and applying Currency lets Excel include it in calculations while showing the symbol. In a formula, $E$1 does not mean that the value in E1 is money; it means the reference to E1 should not shift when copied. You can format E1 as currency separately if its value represents an amount.

Frequently Asked Questions

Why does Excel show #### instead of a dollar amount?
A column that is too narrow is a common reason. Widen it or use a smaller display format. If the value is a date or time, a negative or unsupported value can also produce ####, so check the underlying value as well as the width.

How do I keep a dollar sign in a formula when I drag it down?
Edit the formula, select the cell reference you want to keep fixed, and press F4 until it has the dollar signs in the right positions. Use $A$1 to lock both the column and row, or a mixed reference such as A$1 when only the row should stay fixed.

Why does Ctrl+Shift+$ not apply currency formatting?
The shortcut can be affected by keyboard layout, laptop function-key settings, or the selected app context. Select the cells and use Home > Number > Number Format > Currency instead. You can also choose a symbol and decimal settings in Format Cells.

Does a dollar sign in Excel turn a number into currency?
No. A dollar sign in a reference such as $A$1 locks the reference when a formula is copied. Currency formatting controls how a numeric value is displayed. A dollar sign typed as part of ordinary cell text is just a character.

Why can’t I calculate a value after typing a dollar sign?
The entry may have been stored as text, especially if the sign was typed into the cell along with the amount or the cell was formatted as Text. Enter the numeric amount as a number, convert text values where appropriate, and apply Currency formatting to show the symbol.

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.