+phone numbers not treated as formulas

[Tim]

Hi I want to make a list of international phone numbers starting with the +
sign.

I can not work out how to stop the cell being treated as a formula, i have
the cell formated as text.

thanks tim

 

[ScottO]

You can put a single quote mark in front - eg '+613xxxxxx
Rgds,
ScottO

| Hi I want to make a list of international phone numbers starting with the
+
| sign.
|
| I can not work out how to stop the cell being treated as a formula, i have
| the cell formated as text.
|
| thanks tim
|
|

 

[Max]

Another way would be to preformat the entire col as Text
(Select col, then click Format > Cells > Text > OK)

 

[Jack Marks]

In the past, I have always accomplished this by entering a single quote
first, the '. So the cell would look like
'+10-212-234-4444. Note the single quote in front.

 

[^'^BatAttaK^'^]

Hi I want to make a list of international phone numbers starting with the +
sign.

I can not work out how to stop the cell being treated as a formula, i have
the cell formated as text.

thanks tim

Format > Cells > Number > Special > Phone Number