Telephone Numbers in Cells

[jayway]

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

 

[Bernard Liengme]

1) start phone number with apostrophe '07781125331
or
2) format cell with custom format 00000000000 (as may zeros as digits)
best wishes

 

[Niek Otten]

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

 

[Dav]

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 produc
the leading 0 however if you start using numbers of a different lengt
this will produce strange results

regards

Da

 

[jayway]

Thanks a lot guys.

Jayway