Assign Currency Text For Free

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.

To create the dollar sign symbol using a U.S. keyboard, hold down the Shift and press 4 at the top of the keyboard.

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.

Simply hold the Alt key and then type the four-digit code on the numeric keypad. To type a £ sign, you would hold the Alt key and them type 0163. To type a 20ac sign, press Alt and type 0128 and it will appear in the text box or document. You can also type the squared symbol or a degree symbol, among others.

Apply a custom number formatSelect the cell or range of cells that you want to format.On the Home tab, under Number, on the Number Format pop-up menu. , click Custom.In the Format Cells dialog box, under Category, click Custom.At the bottom of the Type list, select the built-in format that you just created.Click OK.

In the Format sidebar, click the Cell tab, then click the Data Format pop-up menu and choose Currency. Do any of the following: Set the number of decimal places: In the Decimals field, type the number of decimal places you want to display. Numbers rounds the display value instead of truncating the display value.

Convert currency to text with formatting with formulaSelect 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.