Centre county Pennsylvania, USA | Ed B, just kidding in above reply, that happens when I see all that Richard text coloured numbers (and strings;). The step I missed was to 1st save your Excel workbook file as a text(tab delimited) or CSV (comma delimited) file, then open it in wordpad or word and save from there as a ANSI encoded text file. That gets it out of Microsoft's spreadsheet and into a file that has the .txt extension that many number crunching executables can handle. I often use that procedure to get Excel stuff in Matlab, sometimes I even use word to search and replace stuff I don't want (like different delimiter) before saving as text file for Matlab import. Another trick is to copy only the data columns you want from Excel workbook onto clipboard and paste that in wordpad or word, then save as ANSI encoded text file. |
Does excel operate as ASC11 files? pbear&others
