iSeries generated csv rendering differently in Excel 2003 vs 2007

[SuzieW]

Hi

I have an RPG program that builds a complicated csv file. One of the "columns" in the csv file needs to contain line breaks within the cell, so in my RPG, I use x'25' to create the breaks within the cell.

Now that I have Excel 2007, I have noticed that when I open the csv file in Excel and click on the cell with line breaks, you can only see the first line, you cannot see the rest of the data. If I save the file as Excel 2003, suddenly the cell opens up and shows the remainder of the data.

This csv is sent out to external parties, so I am not in control of what version of Excel the recipient has. I need to create a csv file that will render these line breaks correctly regardless of the version of Excel.

I have googled, to no avail. Does anyone know how to achieve this or have any other useful suggestions?

Regards

Suzie

 

[SuzieW]

Hi all - ignore the above - the data is all there, but you just need to either expand the cell or scroll down within the cell contents area along the top.

Suzie