Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi, I’m a moderator for this topic and I wonder whether you’re still waiting for an answer. If you are, please let me know and I will do my best to find an Expert to assist you right away. If not, feel free to let me know and I will cancel this question for you. Thank you!
Only export options available are .csv file, new Excel workbook and existing Excel workbook. Ie text file export not available.
Exporting into a .csv file and then importing that into Excel works and numbers are exported as numbers, both in the .csv and subsequent Excel files, thank you.
Any reason why this does not work when exporting directly into Excel?
Fellow engineer Jan
Sorry for the delay in responding. I just got the notification that you have replied (the site was down several times in the past few days)
When importing csv files Excel automatically detects that the file is essentially a text file and uses the text import wizard to parse the data. In doing so it determines which field is text and which field is number and applies the proper format accordingly
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the answers