ExcelBanter - change column format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - change column format (https://www.excelbanter.com/excel-programming/330309-change-column-format.html)

NuB

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.

STEVE BELL

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.

NuB

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.

All times are GMT +1. The time now is 07:24 PM.