DOLLAR
Functions to Convert Excel Data Types

Basic Description

The Excel DOLLAR function rounds a supplied number to a specified number of decimal places and then converts this into text, using a currency format. The currency format used is the format that is set as the default on your computer.

The format of the Excel DOLLAR function is :

DOLLAR( number, [decimals] )

Where the arguments are as follows :

number - The number to be converted into a text string
[decimals] - An optional numerical argument which specifies the number of decimal places to be shown after the decimal point
Note :
  • If [decimals] is omitted, it takes on the default value of 2.
  • If [decimals] is negative, the supplied number is rounded up to the left of the decimal point.

Dollar Function Examples

Dollar Function Common Problem

Common Problem

Once a number has been converted, using the Excel Dollar function, it is stored in Excel as text. Therefore, it cannot be used in numeric calculations.

If you want to be able to use the numbers in calculations, you may prefer to keep the values as numbers in Excel and just change the formatting into a currency format. To do this:

  • Right click with the mouse, on the cell to be formatted
  • Select the Format Cells ... option and ensure the Number tab is selected
  • Under the Category heading, select the option Currency
  • From the options that appear on the right, specify the details of the formatting required
  • Click OK
Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.