DOLLAR

Convert number to currency (Dollar) in Excel
Convert number to currency (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.

Keep Reading Similar Functions:

Round a number to decimal places with or without commas in Excel

FIXED

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

Read More »
Convert a text string without number format in Excel

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

Read More »
Converts number Thai currency Excel

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 “ห้าบาทห้าสิบสตางค์”.

Read More »