Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

This question already has an answer here:

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?

share|improve this question

marked as duplicate by Al E., Alex, jonsca Jan 3 at 22:13

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

add comment

2 Answers 2

up vote 7 down vote accepted

It's the plus sign.

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

share|improve this answer
    
This seems like a workaround; you can append any character at all and prevent the cell from being interpreted as a number. The quote is still visible. Is there a better way? –  fatuhoku Jul 4 '13 at 10:51
    
I take that back; omit any spaces in the number and the single quote will disappear. –  fatuhoku Jul 4 '13 at 10:55
    
One side note: If specifically chosen "Plain Text" for cell number type in given range of cells, above method will not work and will try to show that single quote (for which it adds another single quote as prefix). Strange thing is even hough you specify that what you enter supposed to be treated as text, it deletes plus sign. So when you type numbers beginning with plus or minus sign you can use above method (adding single quote) but when number type is defined as "Normal" for that range. Should it be considered as a bug? –  Bogac Aug 1 '13 at 11:20
add comment

You just need to wrap your text in formula: =("+1+2+3-123")

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.