Remove Decimal Points

I have the following summary string used in a Group Footer
=Count(Fields!Title.Value) &" Opportunities worth: " &
Format(Sum(Fields!Estimated_Value.Value),"C")
it gives the proper results
7 Opportunities worth $750.60
How can I remove the decimal points from the formatting?How about Format(Sum(Fields!Estimated_Value.Value),"C0")
On Mar 5, 1:28=A0pm, BLAW <brad...@.gmail.com> wrote:
> I have the following summary string used in a Group Footer
> =3DCount(Fields!Title.Value) &" Opportunities worth: " &
> Format(Sum(Fields!Estimated_Value.Value),"C")
> it gives the proper results
> 7 Opportunities worth $750.60
> How can I remove the decimal points from the formatting?|||Thanks! Easy fix. Any help on
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2be09ac8fcf5e49a/5238a4bc8bd90c98#5238a4bc8bd90c98
?