Format all data as Text (not General) when exported to Excel

Question

I have an SSRS report with no column format settings. It's a blank slate. When I export to Excel, all cells have the "General" format.

The problem is that I need all cells in the spreadsheet to have the "Text" format. Is there anything I can do on the SSRS side so that all cells in the spreadsheet have the "Text" format, and not the "General" format?

Answer 1

Can you edit your data on report to have single quote (') on the first position.
Excel numbers, dates, and others non texts ('81111231456) recognize as text.