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

Perhaps:

$#.0,

--
Jim
"watchtower" wrote in message
...
|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

Got it... Custom formatting 0,

"watchtower" wrote:

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

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

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


"Jim Rech" wrote:

Perhaps:

$#.0,

--
Jim
"watchtower" wrote in message
...
|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

On 24 Jul, 19:32, watchtower
wrote:
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