Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form
It works OK on my computer
"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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form
Hi,
In the cell the the format is phone number, Format-Cells-Number-General-Phone Number. When you enter the information in the Form it is Format-Cells-Number-General. Therefore, select the wroksheet, Crtl+A and change the format. Challa Prabhu "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
File in 2007 form - need to get back to 2003 form... | Excel Discussion (Misc queries) | |||
Can a form made in Excel 2002 be converted into a fillable form? | Excel Discussion (Misc queries) | |||
how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
how can I make a form number change everytime the form is opened | Excel Worksheet Functions |