Trythis
Range("A1").Value = Format(Me.TextBox1.Value, "(000) 000-0000")

"glenda" wrote:

I'm using Excel 2003. I have a column formatted as phone numbers. When I
enter a phone number in a cell, then press enter, it takes me to the next row
and the number is formatted correctly: (317)123-4567. However, when I enter
the information in a form, it is not formatted correctly, it looks like this:
3171234567. I tried highlighting the column and changing the format of the
cells, but that doesn't change the way the info appears. The only way I can
get it to show up correctly is by changing each individual cell. What am I
doing wrong?