To retrieve plus sign (+) together with number from web

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.

Thank you so much for your help. You're right - All positive numbers will have "+" added in front. Is there any way to fully import the original string (e.g. "+ 1") into the spreadsheet, without auto-adjusting the format?

What's problematic is that the on-line source doesn't consider "+" as a positive indicator. It's simply a sign added before a number. So other sample values include "* 1" or simply "1". There's a need to distinguish "+ 1" and "1".

Again, thanks a lot for joining the discussion.

No, just wanna simply use the get external data button to retrieve data.

Tried. All cells are set as Text before importing. After importing, those "+ 1" become "1", though the Format is still Text.

Also tried to check/uncheck the "Preserve cell formatting" box, but the results are the same. The only difference is that the Format becomes General if the box is unchecked. Any way to stop Excel from auto-recognising "+ 1" as a number but text before importing?