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.