Number starting with zero

[twinkle17]

I have a column in a table where I need to enter phone numbers in. I want
them formatted the same no matter how people enter them - two digits for area
code, then space, then four digits, space, four digits. The area code will
always start with zero. I have tried to enter a custom format as ## ####
#### and even tried putting brackets around the first two ## however it
always drops the zero.

How can I fix this?

Thanks

Kathryn

 

[Tom]

I have a column in a table where I need to enter phone numbers in. I want
them formatted the same no matter how people enter them - two digits for
area
code, then space, then four digits, space, four digits. The area code
will
always start with zero. I have tried to enter a custom format as ## ####
#### and even tried putting brackets around the first two ## however it
always drops the zero.

How can I fix this?

Microsoft explains this better than I can:

http://support.microsoft.com/kb/81518

Tom

 

[Per Jessen]

Custom format: 0# #### ####

Regards,
Per

 

[twinkle17]

Thanks guys - all fixed.

Custom format: 0# #### ####

Regards,
Per

 

[helene and gabor]

enter number as a word: ="08910763"

 

[helene and gabor]

enter phone number as a word:= "07654320851"