I'm putting together a profit and loss report in SQL Server Reporting Services (SSRS). I need to *display* a number, e.g. 1023488.06, as 1,023.5. I've gotten as far as putting #,#,;(#,#,);- in the format property of the relevant textboxes. This yields 1,024. I don't want to do this via dividing by 1000 and rounding, because users of the report will want to export these online reports into Excel and manipulate them. So I need to preserve the dollars and cents. I just want to change the display of the data, not the data.