Thank you so much in advance for helping on this question related to importing data from web.

I would like to import a table which contains cells showing "+1". But every time when the data is imported and shown in the spreadsheet, they become "1" automatically. The plus sign ("+") is left out as the value is recognised as positive 1 directly. How can I fully import the string "+1"? Pre-setting the cell format to Text before importing can't prevent the data to be auto-adjusted from "+1" to "1".

Thanks a lot for your kind help.