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

1. Microsoft Office Excel 2007 Tutorial
2. Text functions
3. DOLLAR

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

22.7.DOLLAR
	22.7.1.	DOLLAR 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
	22.7.3.	=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 Text