Text Functions MSOfficeExcel 2007 Tutorial

Input the formula: =TEXT(A1,"$#,##0.00")