Display zeros in a table without characters

A

anonymous

I'm attempting to input a telephone extension number in a
table and cannot for the life of me work out how to
display the zeros at the beginning of the number.
For example: 011
Access always removes the 0 and just displays 11
HELP!!!
 
C

Cheryl Fischer

Sounds like the DataType of your Extension field is Number. Make it Text,
and you can enter the leading zeros.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time format hh:nn drops leading zero 0
Adding recognised Zeros 5
Problem with MS Word paragraph and character styles: format getting messed up 2
Droping Leading Zeros In Table 2
How I import data without truncating zaro in the beginning 1
Leading character and zeroes to pad field entries 6
Leading Zeros 6
leading zeros 6

Top