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

Enrique,
This was EXACTLY what I needed!

Thanks,
Lisa

[quoted text, click to view]


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

[quoted text, click to view]


You're welcome. Let me know if I can be of further assistance.

Regards,

Enrique Martinez
Sr. Software Consultant