Right Align Dollar Signs

Hello Everyone,

Does anyone know where I can go to get the format to make

$ right align + =Sum(Fields!Blah.Blah) as #,###.00?

||

|$ 23.00|

|$ 1,000.00|

||

I can not figure out how to get the dollars to right align like Excel ?

Please point me to the answer or a previous post that answers this...

Make two separate columns. The first column can have dollar signs and then make the right column right aligned with the number formating of N (Right click on the cell, go to properties. Click on the format tab and type "N" in Format Code)
|||Is this to apply to a Matrix?|||Thanks for the quick answer....Hope next version has a better solution...