Display number in thousands

How do I display a number in thousands rather than the full numer
e.g. 100,000 as 100. THis is for a financial report and managers are not
interested in numbers in the hundreds. I know i can divide by a thousand.
But can the Format command do it instead
--
Gerry Connolly"GerryC" wrote:
> How do I display a number in thousands rather than the full numer
> e.g. 100,000 as 100. THis is for a financial report and managers are not
> interested in numbers in the hundreds. I know i can divide by a thousand.
> But can the Format command do it instead
> --
> Gerry Connolly|||I am assuming that you are using Report Designer.
Textbox formatting functionality supports custom format strings. To reach
this functionality right click in a textbox and select Properties. From there
navigate to the Format tab and click on the "..." button associated with the
Format Code option.
Select the Custom option on the Choose Format dialog. You may want to review
the Formatting Numeric and Date Values in a Report topic in SQL Server 2005
Books Online at http://msdn2.microsoft.com/en-us/library/ms157406.aspx
"GerryC" wrote:
> How do I display a number in thousands rather than the full numer
> e.g. 100,000 as 100. THis is for a financial report and managers are not
> interested in numbers in the hundreds. I know i can divide by a thousand.
> But can the Format command do it instead
> --
> Gerry Connolly