Export to Microsoft Excel from IE

[Guest]

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

 

[Guest]

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

 

[Guest]

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