Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set the Column/Length format on an Excell sheet
Hello,
When I import an Excel spread sheet to my Access DB table, each Column on my Access Table gets the default Field Size of 255 with the format of @... How can I set the lengths of a column to an specific size and format, i.e. 40 char. or Telephone number, or ? I tried difrent combination of the following with no success: Sub FmtCell() Range("A1").EntireColumn.Format.Text = ("Text") Range("B1").EntireColumn.Format.Special ("Phone") End Sub -- Jeff B Paarsa |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set the Column/Length format on an Excell sheet
Try recording a macro when you have a problem like this
Columns("").NumberFormat = "@" Columns("B").NumberFormat = "[<=9999999]###-####;(###) ###-####" "Jeffery B Paarsa" wrote: Hello, When I import an Excel spread sheet to my Access DB table, each Column on my Access Table gets the default Field Size of 255 with the format of @... How can I set the lengths of a column to an specific size and format, i.e. 40 char. or Telephone number, or ? I tried difrent combination of the following with no success: Sub FmtCell() Range("A1").EntireColumn.Format.Text = ("Text") Range("B1").EntireColumn.Format.Special ("Phone") End Sub -- Jeff B Paarsa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell dragging formula to change sheet/tab not column/row | Excel Worksheet Functions | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
editing documents with excell that are not excell format | Excel Discussion (Misc queries) | |||
formula/check for doubling in column in Excell sheet | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) |