Number Format after Exporting to Excel from Reporting Services

I suddenly have a large amount of users asking me why they can't do
sums on Excel 2003 exported Reporting Services reports. The numbers
in the cells are not formatted as numbers nor does it appear like you
can change it within Excel. Some are retypeing number into each
column.
Is this something I can control within Reporting Services or does
something need to be done within Excel after the export.
Any help would be great.
Thanks,
MikeOn Jul 13, 12:52 pm, michael h <mikej...@.gmail.com> wrote:
> I suddenly have a large amount of users asking me why they can't do
> sums on Excel 2003 exported Reporting Services reports. The numbers
> in the cells are not formatted as numbers nor does it appear like you
> can change it within Excel. Some are retypeing number into each
> column.
> Is this something I can control within Reporting Services or does
> something need to be done within Excel after the export.
> Any help would be great.
> Thanks,
> Mike
You might be able to convert the numbers via an expression and that
way it can export and be recognized as an integer/long value. An
expression similar to this might work.
=CInt(Fields!FieldName.Value)
-or-
=CLng(Fields!FieldName.Value)
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant