Number starting with zero

  • Thread starter Thread starter twinkle17
  • Start date Start date
T

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
 
twinkle17 said:
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?
Click to expand...

Microsoft explains this better than I can:

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

Tom
 
Back
Top