conditional formatting of currency field?

[Jen]

Hi there,

I'm trying to produce a salary list that includes
both "$xx,xxx" and "$x.xx per hour" formats. Our table
contains just the numerical values, and the field is set
as currency. Is there an easy way to produce the mixed-
format list we want, or do we have to convert the field to
text and add in all the $ signs? If so, will the "auto"
setting take care of the changing decimal needs (none for
salaries, 2 for wages)?

Thanks
jen

 

[SA]

Jen:

Use the Format function as in:

=Format (MyCurrencyField, "$#,###")

and

=Format (MySecondCurField, "$#,###.00)

 

[Jen]

If i'm reading this right, this requires the different
numbers to be in two different fields, right? All of our
numbers are in the same field; we want to set anything
from 0-999 to read as $#.##, and anything >1000 to read as
$#,###. Is that possible?

thanks
jen