469,366 Members | 2,342 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Exporting SSRS report to Excel - Number stored as Text error

When exporting a report to excel, is it possible to keep the properties around numeric values? More specifically - when exporting a report into excel, all of the numbers in a currency column are stored as text once placed into excel. Is there a way to keep them as a currency value?


Regards,
Nanditha
Dec 5 '08 #1
3 11098
Curtis Rutland
3,256 Expert 2GB
I've had a similar problem, that I couldn't solve. If anyone knows the answer, I'd also appreciate it.
Dec 5 '08 #2
I am able to resolve this. the method is dont write a function to convert to currency. specify in properties of the cell (properties->format->format code:C) just to C.

Let me know if it is helpful


Thanks,
Nanditha
Dec 12 '08 #3
I posted earlier and then found a solution. CInt(Sum(Fields!usertotal.Value))

Poseted by Adam Tappis
http://social.msdn.microsoft.com/For...2-61cf7d25fafb
Oct 19 '10 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mike P | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.