how to ex****t with format using TransferSpreadsheet

Hi,

Whenever I ex****t a query (with just one text field) using 
TransferSpreadsheet and I open the Excel sheet to see the result, I
realize 
that each field starts with an apostrophe. How can I get rid of it?

I've noticed that if I ex****t this query my means of the option menu 
"Ex****t" + with format, the Excel sheet has another appearance and there's
no 
apostrophe.
Is there anyway I could set a format programmatically to that field to
avoid 
this issue?

Thanks,
Dario