Commas

To add commas to your numbers:

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

  6. A list of fixed decimal types (which include commas) 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 a type, click OK.

  8. The formatting will be applied to the selected cell(s). Note the that numbers will be values, and thus, can be used in calculations. They will also be included in row and column totals.

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

 

Comma Formatting in Advanced Mode

To apply comma formatting in Advanced Mode:

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

  2. Click the Comma Style button ( , ).

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

 

FIXED function

FIXED(number, precision, no_commas)

Parameter

Description

number

number you want to fix

precision

number of decimal places

no_commas

if TRUE, result will have no commas; if FALSE or omitted, result will have commas

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

  1. Click on the cell you want the insert the fixed value into.

  2. Type in a formula. For example, for 5,000, type =FIXED(5000, 0, FALSE), or simply =FIXED(5000, 0).

  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

=FIXED(5000, 0, TRUE)

5000

=FIXED(5000, 0, FALSE)

5,000

=FIXED(5000, 2, FALSE)

5,000.00

=FIXED(5000, 2)

5,000.00

=FIXED(5000)

5,000.00

=FIXED(4999, 0)

4,999

=FIXED(4999, -1)

5,000

=FIXED(4999, -1, TRUE)

5000