zero's

[Guest]

when i try to enter a phone number in a cell if the first number is a zero it
will not recognise it ???

 

[Douglas J. Steele]

Sounds as though you're storing the phone number as a Numeric field, as
opposed to Text.

Change it to Text: it's not as though you're going to be doing arithmetic on
the number.

 

[Guest]

Hi Douglas J. Steele
when i store it as text i have to format each cell seperatly is this the
only way to do it??

 

[fredg]

Hi Douglas J. Steele
when i store it as text i have to format each cell seperatly is this the
only way to do it??

Cells?
Format each cell separately?
Sounds like your using Excel to me.

You have posted this message to the wrong newsgroup.
The access in this groups name refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for whatever Office program you
are using. I would suggest you include your Windows and Office version
number in the message.