Manage Currency Text For Free

Go to the "Format Cells" dialog box and select the "Number" tab. Under the Category pane, click "Currency" and select a different currency symbol, like the euro symbol. Click the OK button.

In Excel, currency formats are based on the language and regional settings of your computer. This means that if you are working with a file that was created on a computer with different language or regional settings, the currency formats may not display correctly on your computer.

For US dollars, the symbol '$' is sufficient abbreviation, unless there is a mixture of dollar currencies in the text. For other dollar currencies, '$' should be prefixed with the country abbreviation. For all other currencies, write the figure first followed by the currency name, for example, '100 million yuan'.

Available number formats in Excel Select a cell or a cell range. On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells? , and select Number. ... Select the format you want.

Select the cells that you want to format and then, in the Number group on the Home tab, click the down arrow in the Number Format box. Choose either Currency or Accounting.

United States (U.S.) currency is formatted with a decimal point (.) as a separator between the dollars and cents. Some countries use a comma (,) instead of a decimal to indicate that separation.

Tip: You can also press Ctrl+1 to open the Format Cells dialog box. In the Format Cells dialog box, in the Category list, click Currency or Accounting. In the Symbol box, click the currency symbol that you want. Note: If you want to display a monetary value without a currency symbol, you can click None.