Telephone Numbers in Cells

J

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
 
B

Bernard Liengme

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

Niek Otten

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

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
 
Top