View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Matthew[_2_] Matthew[_2_] is offline
external usenet poster
 
Posts: 54
Default 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