Export to Microsoft Excel from IE

A

AndreasSjoberg

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
 
B

bigwheel

You could set a custom format of 000 (3 digits?)
Format>Cells>Number>Custom>Type = 000
 
A

AndreasSjoberg

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...
 
Top