Format Reporting Numbers to Thousands
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
|