Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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:

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 »
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 »