DOLLAR converts a number to text, using the $ (dollar) currency format : DOLLAR « Text functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Text functions
  3. DOLLAR
=DOLLAR(A2, 2): Displays the first number in a currency format, 2 digits to the right of the decimal point

Input the formula: =DOLLAR(A2, 2)
Input the formula: =DOLLAR(A2, 2)








22.7.DOLLAR
22.7.1.DOLLAR converts a number to text, using the $ (dollar) currency formatDOLLAR converts a number to text, using the $ (dollar) currency format
22.7.2.=DOLLAR(A2, -2): Displays the first number in a currency format, 2 digits to the left of the decimal point=DOLLAR(A2, -2): Displays the first number in a currency format, 2 digits to the left of the decimal point
22.7.3.=DOLLAR(A5): Displays the fourth number in a currency format, 2 digit to the left of the decimal point=DOLLAR(A5): Displays the fourth number in a currency format, 2 digit to the left of the decimal point
22.7.4.Displaying Formatted Currency Values as TextDisplaying Formatted Currency Values as Text