Currency

To apply currency formatting:

  1. Select the cell(s) that you want to format.

  2. Go to the Format menu, and click Cells.

  3. A Format Cells window will appear.

  4. Click the Number tab.

  5. In the Category box, click Currency.

  6. A list of currency types will appear in the Type box. Click on a type to select it. When you click on a type, a Sample will be displayed below.  

  7. After selecting the currency type, click OK.

  8. The currency formatting will be applied to the selected cell(s). Note that the numbers will still be numerical values after formatting.

Note: To quickly access the number formatting window, go to the Format menu, and click Number formatting.

 

Currency Formatting in Advanced Mode

To apply currency formatting in Advanced Mode:

  1. Select the cell(s) that you want to format.

  2. Click the Currency Style ($) button.

  3. The selected cell(s) will be converted to the form $ ###,###.## - each number will be given a dollar sign, two decimal places, and commas where necessary.

 

DOLLAR Function

DOLLAR(number, precision)

Parameter

Description

number

dollar amount

precision

number of decimal places; if omitted, will default to two decimal places

Users experienced in entering formulas may prefer to use the DOLLAR function. To use this function:

  1. Click on the cell you want the insert the currency amount into.

  2. Type in a formula. For example, for $5.00, type =DOLLAR(5, 2), or simply =DOLLAR(5).

  3. Press Enter. The result of your formula will appear in the cell. Note that this result can be used in basic calculations (addition, multiplication, subtraction, division); however, it will not be included in totals and subtotals..

Examples:

Formula

Result

=DOLLAR(3)

$ 3.00

=DOLLAR(3, 2)

$ 3.00

=DOLLAR(3, 0)

$ 3

=DOLLAR(3, 4)

$ 3.0000

=DOLLAR(3.7612)

$ 3.76

=DOLLAR(5200)

$ 5,200.00

=DOLLAR(A2)

will display value in cell A2 as a dollar amount

 

International Currency

At the present time, EasySpreadsheet does not feature international currency formatting. You can, however, insert international currency symbols (¥, £, etc.) into your cells. See Inserting Symbols.

 

Dollar Signs and Cell References

In EasySpreadsheet, dollar signs ($) are used in formulas to make absolute cell references (e.g., =$A$1*$C1). It is important to remember that a dollar sign in a formula has nothing to do with currency - it simply tells EasySpreadsheet not to change the row or column if the cell formula is pasted or moved elsewhere. For details on absolute cell references, see Relative and Absolute Cell References.