Format Currency

Does anyone know how to change the currency as follows:
from: $2,332,765 to: $2.3
I've tried several combinations of ($#.#;$#.#;$0.0) and nothing seems
to work
Thanks in advance
LisaOn Jun 13, 12:19 pm, peashoe <peas...@.yahoo.com> wrote:
> Does anyone know how to change the currency as follows:
> from: $2,332,765 to: $2.3
> I've tried several combinations of ($#.#;$#.#;$0.0) and nothing seems
> to work
> Thanks in advance
> Lisa
You could try: $#.0 however, you might need to use an expression/etc
to divide the values by 1 million. (ie., =Fields!Currency.Value/
1000000) assuming that some values will not evaluate to zero. Also,
you might need to accommodate different currency ranges (ie.,
=iif(Fields!Currency.Value >= 100000, Fields!Currency.Value/1000000,
Fields!Currency.Value/100000). In this example case, if values will
fall below 0.0, then divide by a smaller value/denomination. Of
course, it would need to be based on your particular needs. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Enrique,
This was EXACTLY what I needed!
Thanks,
Lisa|||On Jun 13, 1:36 pm, peashoe <peas...@.yahoo.com> wrote:
> Enrique,
> This was EXACTLY what I needed!
> Thanks,
> Lisa
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant