I want to format a number like "#,##0.00" in order to handle it in Excel as a number (i.e. compute a sum).
Excel is able to show a number in a specail format and still allow to compute with ...
Thanks in advance,
Peter
What problem are you having? If you have #,##0.00 set as your format code, you should be able to export to Excel and then do a sum on that column.
Jarret
|||It doesn't work in my Excel neither with 1 value nor with many values - the sum is 0 anytime.
Peter
|||I found this on another post (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1072895&SiteID=1):
Apply formatting using N in the Format property, then in the value textbox, apply an explicit cast of the value. E.g.
=CDbl(Fields!Example.Value)
Hope this helps.
Jarret
No comments:
Post a Comment