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
Search JabSto ::




Custom Search