I am copying a row of phone numbers that are text strings from Excel to Google Sheets.
The phone numbers change from text to formulas when pasted and return
For example, the text
+49 4942 12345678 from Excel becomes the formula
=+49 4942 12345678 when pasted into Sheets and returns
I want to remove the equals sign
=. How can I format the row to show the phone numbers as text again?