Single Quote added automatically in front of numeric data when importing CSV file to Google spreadsheet

Question

When I import a csv file to Google spreadsheet a single quote get added in front of all numeric data. How can I remove that ?

I using import option from file menu

Answer 1

Try this:

1. right-click the column letter (on columns with numbers)
2. press Ctrl+F to invoke Google Sheets Search
3. to the right of the search box, click the ? vertical 3 dots button to invoke the Find and replace window
4. in the Find box, put the ' single quote (no space after)
5. leave the Replace box empty
6. click the Replace all button (on the bottom)

That should do the trick