Format Reporting Numbers to Thousands

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Try this one. Zeros will be the dash "-" and negative numbers will be in
parentheses.

_( #,##0,_);_( (#,##0,);_(* "-"_);_(@_)
 
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
Click to expand...

Adam,

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

That 'll do it for you

Matthew
 
Back
Top