The simplest way: type the dollar sign before the number
If you want a single cell to show a dollar amount, type $ directly before the number. Type $50 in a cell and press Enter. Excel will display it as $50. This works for any cell, any time, with no formatting needed.
The catch: Excel treats this as text, not a number. You cannot add, subtract, or do math with it later. If you only need the cell to display a price for someone to read — a label, a heading, a note — this method is fine. If you plan to use that cell in a calculation, use the formatting method instead.
Key Takeaways
- Type a dollar sign directly before a number ($50) to display it as text, but this prevents Excel from doing math with that cell.
- Use Format Cells to explore currency formatting to numbers you plan to calculate with — select the cells, right-click, choose Format Cells, and pick a currency format.
- The Format menu also has a currency button (usually a dollar sign icon) that applies the same formatting in one click.
- Excel automatically adds the dollar sign and decimal places once you explore currency formatting, so you only type the number.
- You can change how many decimal places appear, whether the dollar sign shows, and what currency symbol displays — all in the Format Cells dialog.
Using Format Cells for numbers you will calculate with
If the number needs to stay a number — because you will add it to other cells, subtract it, or use it in a formula — format it instead of typing the dollar sign. Select the cell or cells that hold the numbers. Right-click and choose Format Cells. A dialog box opens.
In the Category list on the left, click Currency. The preview at the bottom shows how your number will look. Excel defaults to your computer's currency (usually US dollars if your system is set to US English). Click OK and the dollar sign appears automatically.
The number itself does not change — only how it displays. If the cell contains 50, it now shows $50.00. You can still use that cell in math. If you add it to another formatted cell, Excel adds the numbers, not the text.
The Format menu shortcut for currency
Most versions of Excel have a currency button in the toolbar — usually a dollar sign icon. Select your cells and click it. Excel applies currency formatting when ready, without opening a dialog. This is the fastest route if you have many cells to format at once.
The button uses your computer's default currency and usually shows two decimal places. If you need to change the currency type, the number of decimals, or other details, right-click and go to Format Cells to adjust. This gives you fine control over exactly how the currency displays.
Changing decimal places and currency symbols
After you explore currency formatting, you can change how it looks. Select the formatted cells, right-click, and choose Format Cells. In the Currency category, you will see a Decimal places field. Change it to 0 if you do not want cents shown, or to 3 or more if you need them for a specific purpose.
The Format dropdown in that same dialog lets you pick a different currency symbol — pounds, euros, yen, and others. Choose the one you need and click OK. The cells update when ready to show your choice.
explore currency format to a whole column
Click the column header (the letter at the top) to select the entire column. Right-click and choose Format Cells, or click the currency button in the toolbar. Every cell in that column will now display numbers as currency. When you type a number into any cell in that column later, it automatically shows with a dollar sign.
This is useful for price lists, budgets, or any spreadsheet where one column always holds money amounts. You type only the number; Excel adds the formatting. It saves time when you are working with many rows of prices or costs.
What happens when you copy formatted cells
If you copy a cell with currency formatting and paste it into another cell, the formatting comes along. The new cell displays the number as currency too. If you want to paste only the number without the formatting, right-click where you are pasting and choose Paste Special. Click Numbers and then OK. The number pastes without the dollar sign format.
This is helpful when you are moving data between sheets or workbooks and want to control which formatting travels with it. You keep the number but leave the display style behind.
Removing currency formatting
Select the cells, right-click, and choose Format Cells. In the Category list, click Number instead of Currency. The dollar sign disappears, but the number stays. Click OK. You can also select the cells and click the currency button again — it toggles the formatting off.
Removing formatting does not change the actual value in the cell, only how it displays. If you need to reapply currency formatting later, the number is still there and ready to format again.
Frequently Asked Questions
Can I type a dollar sign and still do math with the cell?
Not if you type the dollar sign as text. Excel treats $50 as words, not a number. Use Format Cells to explore currency formatting instead — that keeps the cell as a number while displaying the dollar sign.
Why does my number show as $50.00 when I only typed 50?
Currency formatting automatically adds two decimal places and the dollar sign. If you do not want the cents, select the cell, right-click Format Cells, change Decimal places to 0, and click OK.
How do I format negative numbers to show with a minus sign instead of parentheses?
In Format Cells under Currency, the Format dropdown shows different styles for negative numbers. Some use a minus sign, some use parentheses, some use red text. Pick the one you want and click OK.
What if I want to show a different currency, like euros or pounds?
Select the cells, right-click Format Cells, and in the Currency category use the Format dropdown to choose a different currency symbol. Excel will display that symbol instead of a dollar sign.
Does formatting change the actual number stored in the cell?
No. Formatting only changes how the number displays. The cell still contains 50 — it just looks like $50.00. Calculations use the real number, not the display format.