How to export from SSRS some blank columns in a report that user will be entering data into appear as text?

Question

Currently, the exported Excel columns are of type General and when user enters values like 06-71, iit converts it to a date format. However, it should be treated as text and remain as is.

Answer 1

when user enters values like 06-71, iit converts it to a date format

That's the way MS Excel works; has nothing to do with SSRS/Export.

You can add an apostrohpe in front of the value to supress this MS Excel behaviour.

Answer 2

Hi @Manveet Kaur，

The easiest way is right click the cells in Excel file and format the cells as text.

There is some limitation when export to Excel from SSRS report.

Directly edit the excel file may be the fast way.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.