Telephone Numbers in Cells

Hi

I want to put a telephone number starting with 0 in a cell but
everytime I do so it automatically removes the 0. For instance
07781125331 would become 7781125331. How do I get around this?

Thanks

Jayway

1) start phone number with apostrophe '07781125331
or
2) format cell with custom format 00000000000 (as may zeros as digits)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jayway" <jayway@hotmail.com> wrote in message
news:1138809974.428595.89620@o13g2000cwo.googlegroups.com...
> Hi
>
> I want to put a telephone number starting with 0 in a cell but
> everytime I do so it automatically removes the 0. For instance
> 07781125331 would become 7781125331. How do I get around this?
>
> Thanks
>
> Jayway
>

Precede the number with an apostrophe. The apostrophe will not show in the
cell.

--
Kind regards,

Niek Otten

"jayway" <jayway@hotmail.com> wrote in message
news:1138809974.428595.89620@o13g2000cwo.googlegroups.com...
> Hi
>
> I want to put a telephone number starting with 0 in a cell but
> everytime I do so it automatically removes the 0. For instance
> 07781125331 would become 7781125331. How do I get around this?
>
> Thanks
>
> Jayway
>

Either format the cell as text
type the phonenumber starting with a ' this makes it a text string
format the cells to a custom format 00000000000 and this will produce the leading 0 however if you start using numbers of a different length this will produce strange results

regards

Dav

Thanks a lot guys.

Jayway