DOLLAR

Rational

Convert number to currency (Dollar).

Description

The Excel DOLLAR function display a number with a dollar currency but in a text format. For example, to convert a numerical value to the dollar, the formula can be =DOLLAR(500) returns \$500 as a currency but in a text format.

Syntax

= DOLLAR(number, [decimals])

Parameters

number – A number to convert using currency format
decimal [Optional] – The number of digits to the right of the decimal point

Return Value

Number with currency format

Key Notes

• Number converted using the DOLLAR function is stored as text in Excel.
• The default for decimals is 2. If the decimal argument is negative, the number will round to the left of the decimal point.
• Numbers stored as text returns with an error while using functions such as SUM, AVERAGE, MIN, MAX, etc.
• The DOLLAR function is also susceptible to wrong results as shown above.
• It is preferable to use the Format Cells dialog (Ctrl+1), select Currency > \$ or Home > Number Box> Currency Number Format option to apply a currency formatting to the cell.

VALUE

The VALUE function converts valid numbers with various number formatting (number, date, \$ etc.) into a code number. E.g. “=VALUE(“31-12-2017”)” returns “43100”.

FIXED

The FIXED function displays a number in a text format after rounding the specified number of decimal places with or without commas.

BAHTTEXT

The Excel BAHTTEXT function converts a number to Thai currency with a suffix of “Baht”. I.e., to translate \$5.50 in cell B7 =BAHTTEXT(B7) returns “ห้าบาทห้าสิบสตางค์”.