+phone numbers not treated as formulas

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

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

"Tim" <[email protected]> wrote in message
news:[email protected]...
| 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
|
|

Another way would be to preformat the entire col as Text
(Select col, then click Format > Cells > Text > OK)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

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.
"Tim" <[email protected]> wrote in message
news:[email protected]...
> 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
>

On Thu, 14 Jul 2005 15:24:56 +1000, "Tim" <[email protected]> wrote:

>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