I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and paste to convert numerical data to text in a column?
Or, am I going about this all wrong because there's a better way to get all cell data enclosed in quote marks for export to CSV?