| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change column format
how can i change the format of the column from general to number?
instead of seeing 2.00504E +11 i want to see 200504140012 How can i make this happen in code? the file is being populated from another excel file. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change column format
Columns("A:A").NumberFormat = "0"
or Columns("A:A").NumberFormat = "000000000000" ' this one will alway show 12 digits ' -- rand451 "NuB" <CSharpCoder wrote in message ... how can i change the format of the column from general to number? instead of seeing 2.00504E +11 i want to see 200504140012 How can i make this happen in code? the file is being populated from another excel file. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
change column format
thanks
"STEVE BELL" wrote in message news:ipHle.9974$GN3.3896@trnddc04... Columns("A:A").NumberFormat = "0" or Columns("A:A").NumberFormat = "000000000000" ' this one will alway show 12 digits ' -- rand451 "NuB" <CSharpCoder wrote in message ... how can i change the format of the column from general to number? instead of seeing 2.00504E +11 i want to see 200504140012 How can i make this happen in code? the file is being populated from another excel file. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i change column header from R[1] C format to A1 format? | Excel Discussion (Misc queries) | |||
| How do I change the row/column format in a macro to beyond letters? | Excel Discussion (Misc queries) | |||
| WHY DOES DATE FORMAT CHANGE IN COLUMN | Excel Discussion (Misc queries) | |||
| Can I change a column of dates from USA to UK format? | Excel Discussion (Misc queries) | |||
| Both columns change when I format only one column (A) | New Users to Excel | |||
Linear Mode
