I’m having a weird issue with google sheets.
I have a column full of cells with #ERROR!.

This is happening because in each cell it was added phone numbers in this format: +34 656 66 66 66.

Of course, Sheets is interpreting as a formula so it shows #ERROR!.

I’ve tried the following:

• Copy the CELL into another one and format it: =TEXT(C1, "@"). The error still shows in the other cell.
• Export the file as CSV. The error still shows.
• Create a Macro to replace it manually. However the changes detected are as a full replacement of the cell.

function CHANGETONUM() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('C2').activate();
  spreadsheet.getCurrentCell().setValue(''=34 647 96 54 46');
};

I have no ideas left, how would you go for it?

Regards,