Format Reporting Numbers to Thousands

[Guest]

I am trying to format numbers to show in thousands for reporting... for
example:

$19,899 Nineteen thousand eight hundred and ninety-nine dollars should
display as
$19.9

I would rather not enter into the formulas... hopefully there is a custom
format to use.

Thanks,
Adam

 

[Jim Rech]

Perhaps:

$#.0,

--
Jim
|I am trying to format numbers to show in thousands for reporting... for
| example:
|
| $19,899 Nineteen thousand eight hundred and ninety-nine dollars should
| display as
| $19.9
|
| I would rather not enter into the formulas... hopefully there is a custom
| format to use.
|
| Thanks,
| Adam

 

[Guest]

Got it... Custom formatting 0,

 

[Guest]

Try this one. Zeros will be the dash "-" and negative numbers will be in
parentheses.

_( #,##0,_);_( (#,##0,);_(* "-"_);_(@_)

 

[Matthew]

I am trying to format numbers to show in thousands for reporting... for
example:

$19,899 Nineteen thousand eight hundred and ninety-nine dollars should
display as
$19.9

I would rather not enter into the formulas... hopefully there is a custom
format to use.

Thanks,
Adam

Adam,

In the format cells box go to custom and enter $#.0,

That 'll do it for you

Matthew