Not Enough Room in a Cell

[Napoleon Joe]

I'm trying to input data in a cell. It normally accepts a six-digit number,
but I have two particular cases that need the six-digit number, then a
hyphen, and six additional digits. The field will not allow me to do this.
Can anyone tell me how to fix this problem?

Thanks in advance.

 

[Douglas J. Steele]

While you mention "cell", which is an Excel term, I'll assume you're talking
about a table in Access.

It would appear that you declared the field's size to be less than 11
characters. If it's a text field, you'll need to go into the table design
and increase the declared size. If it's numeric field, you're out of luck:
what you're describing cannot be stored in a numeric field.