I would give them an Excel template (.XLT) with all the necessary headings & formats in and ask them (nicely) to import the CSV data into it rather than just opening it with Excel. The template could also hold any fancy formulae etc. they want to use on the data. Regards, Peter Borton
________________________________ From: The IBM z/VM Operating System [mailto:ib...@listserv.uark.edu] On Behalf Of Schuh, Richard Sent: 20 April 2010 18:27 To: IBMVM@LISTSERV.UARK.EDU Subject: Converting Text to XLS Does anyone know of a program to create an XLS file from a text file on CMS? The file can be sent as a CSV file attached to an e-mail; however, opening the CSV file with Excel or other spreadsheet programs exposes a few formatting problems/inconsistencies that must be fixed by manual manipulation. Regards, Richard Schuh