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
|