Scaling a number by multiple of Thousands

  • Thread starter Thread starter Edward S
  • Start date Start date
E

Edward S

I would like to display numbers in Thousands like
$2,159,260 to be displayed as $2.159. I have tried by using #,, and
it works, but however if the number is less than a million I want the
number with a leading zero for example:
$159,260 to be displayed as 0.159 and currently it does not do that

In microsoft Excel the number format for scaling a number down is
#,##0.000,,

I do not know how to make it work in Access. I am using Access 2000

Any help will be appreciated

Regards
Edward
 
Back
Top