Microsoft Office Tutorials and References

In Depth Information

**Syntax**

The DOLLAR function takes the following arguments:

•
number

number
—
This is a number, a reference to a cell that contains a num-

ber, or a formula that evaluates to a number.

•
decimals

decimals
—
This is the number of digits to the right of the decimal

point. If decimalsis negative, numberis rounded to the left of the

decimal point. If you omit decimals, it is assumed to be 2.

Syntax

=FIXED(number,[decimals],[no_commas])

The FIXED function rounds a number to the specified number of decimals,

formats the number in decimal format using a period and commas, and returns

the result as text. The major difference between formatting a cell that con-

tains a number with the Format Cells dialog and formatting a number directly

with the FIXED function is that FIXED converts its result to text. A number

formatted with the Format Cells dialog is still a number. This function

takes the following arguments:

•
number

number
—
This is the number you want to round and convert to text.

•
decimals

decimals
—
This is the number of digits to the right of the decimal

point. Numbers in Microsoft Excel can never have more than 15 signi-

ficant digits, but decimalscan be as large as 127. If decimalsis negat-

ive, numberis rounded to the left of the decimal point. If you omit

decimals, it is assumed to be 2.

•
no_commas

no_commas
—
This is a logical value that, if TRUE, prevents FIXED

from including commas in the returned text. If no_commasis FALSE or

omitted, the returned text includes commas as usual.

Converting Number Punctuation Using the

Converting Number Punctuation Using the
NUMBERVALUE

Functions

The NUMBERVALUE function is new in Excel 2013. You might receive a data

file from a foreign subsidiary where they use commas for the decimal separ-

ator and periods for the thousands separator. These values never import to

Excel as numbers
—
they end up as text.

You can use NUMBERVALUE to convert them to numbers. Specify the text,

the character used as the decimal separator, and the character used as the

thousands separator. Excel extracts the digits and gets the decimals in the

correct place.

NUMBERVALUE
Functions