View Single Post
  #2   Report Post  
bigwheel
 
Posts: n/a
Default 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