Create Currency Text For Free

To do this, select the cells you want to format. Then, choose Currency from the Number Format dropdown menu in the Number section of the Home tab. All numbers in selected cells are formatted as Currency with the Windows default currency symbol application.

Format numbers as currency in Excel for the web 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.

Convert currency to text with formatting with formula Select a blank cell beside the currency column, says Cell C2, enter the formula =TEXT(B2,"$ #,##0.00 ;") (B2 is the cell with the currency you will convert ) into it, and then drag this cell's AutoFill Handle to the range as you need.

Generally, you should use the Format Cells dialog (Ctrl+1) or Home > Number > Accounting Number Format option to apply a currency formatting to a cell.

On the Home tab, click the Dialog Box Launcher next to Number. 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.

Examples: Two hundred five dollars. Two hundred dollars and fifty cents. Two hundred and 50/100 (written on a check, with the word Dollars preprinted at the end of the line)

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'.