| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Microsoft Excel in Microsoft works - how to open | Excel Discussion (Misc queries) | |||
| Want to buy just EXCEL 2003 not the entire microsoft office suite | Excel Discussion (Misc queries) | |||
| export excel to Front Page | Excel Discussion (Misc queries) | |||
| Microsoft Excel tries to load front page on opening | Excel Discussion (Misc queries) | |||
| Access -> Excel: How to export fields > 255 characters | Excel Discussion (Misc queries) | |||
Linear Mode
