View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
watchtower watchtower is offline
external usenet poster
 
Posts: 25
Default Format Reporting Numbers to Thousands

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