prefix the column with an apostraphe ', then excel will know it is a text field

so something like this, select field1 + ''' as field1 from table1