Apr 20 2018
05:48 AM
- last edited on
Jul 12 2019
11:07 AM
by
TechCommunityAP
Apr 20 2018
05:48 AM
- last edited on
Jul 12 2019
11:07 AM
by
TechCommunityAP
I am importing data from AutoChartist.com using From Text in the DATA tab. The data comes in as a .csv file. The values in the cells have quotation marks around the numbers (see file) so that Excel thinks the numbers in the cell are text. How do I get rid of the quotation marks so that I can use the data for calculations?
Thanx
Apr 20 2018 06:01 AM - edited Apr 20 2018 06:04 AM
Hi John,
The most efficient and easy way to do that is to use the Find and Replace tool as follows:
Regards
Apr 20 2018 07:01 AM
Apr 20 2018 07:13 AM
Just in case, Excel adds quotation marks since your numbers have more than 15 digits (max in Excel for numbers representation), thus returns as text with marks.
Perhaps if play with import wizard options you could convert them to numbers directly.
Apr 20 2018 08:18 AM
Thanx, if anybody has any luck with the import wizard let me know. Tried all the combinations in the wizard I could think of and still have the quotation marks.
Apr 20 2018 08:51 AM
John, if you give sample data to import it'll be easier