Export to Microsoft Excel from IE
 

i have a problem when using the right-klick feature "Export to Microsoft
Excel" from Internet Explorer. The problem is that begining zeros (0)
disappears in the export. A result in IE that looks like this :
AreaCode
010
030
100

Appears i Excel like this:
AreaCode
10
30
100

Trying to change the format of the cells in Excel to text and then refresh
data doesn't help...
Any suggestions?

/Andreas

Export to Microsoft Excel from IE
 

You could set a custom format of 000 (3 digits?)
FormatCellsNumberCustomType = 000

"AndreasSjoberg" wrote:

i have a problem when using the right-klick feature "Export to Microsoft
Excel" from Internet Explorer. The problem is that begining zeros (0)
disappears in the export. A result in IE that looks like this :
AreaCode
010
030
100

Appears i Excel like this:
AreaCode
10
30
100

Trying to change the format of the cells in Excel to text and then refresh
data doesn't help...
Any suggestions?

/Andreas

Export to Microsoft Excel from IE
 

Thank you bigwheel

That solved my concrete example, but what I really need is a more general
solution. Because I dont know beforehand what column/columns that will have
begining zeros (0) and I dont know how many digits/chars the data in
respective columns have...


"bigwheel" wrote:

You could set a custom format of 000 (3 digits?)
FormatCellsNumberCustomType = 000

"AndreasSjoberg" wrote:

i have a problem when using the right-klick feature "Export to Microsoft
Excel" from Internet Explorer. The problem is that begining zeros (0)
disappears in the export. A result in IE that looks like this :
AreaCode
010
030
100

Appears i Excel like this:
AreaCode
10
30
100

Trying to change the format of the cells in Excel to text and then refresh
data doesn't help...
Any suggestions?

/Andreas