format on export to excel

Question

Hi,
When I export a report to excel I see all columns as text formatted fields.
How does the formatting work on export?
Do the number fields get exported to excel as number formatted columns and general format in ssrs get exported as text columns?
Thanks

Answer 1

Hi Arkiboys,

Base on my test, the number fields get exported to Excel as number columns. Because we can add number filters to the columns which are number fields in the report.

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.  

---

Charlie Liao
TechNet Community Support

Answer 2

Hi Arkiboys,

Base on my test, the number fields get exported to Excel as number columns. Because we can add number filters to the columns which are number fields in the report.

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.  

---

Charlie Liao
TechNet Community Support

Hi,
How about if the field in the report is like £25.4
Does that still comeout as number format in excel or text?
Thanks

Answer 3

Hi Arkiboys,

If the field in the report is like £25.4, it's still as number columns after export to Excel.

Regards,

---

Charlie Liao
TechNet Community Support