Google Spreadsheets: format cells as plain text

Question

I'm gathering some data in a Google Spreadsheet, there's a column for phone numbers and when trying to enter a phone number (e.g., +54 11 4785 7992) the spreadsheet automatically tries to make a formula or something like that and shows #ERROR.

I tried to set the cells as PLAIN TEXT but it continues assuming that I want a formula and not just plain text and I don't know why.

Any help?

Answer 1

It's the plus sign.

Prepend your text with a single quote ('). That should allow you to display the number as you want.