Take special care with date values... Over here in Leftpondia, date values are (normally) 'dd-mm-yy', or some variation thereof. This can lead to some difficulties when sending data from m/f to pc. As Mike says, surround such values with quotes, thus forcing Excel to treat them as text strings rather than numerics
Good Luck! Sean On Tue, 3 Sep 2019 at 07:31, Mike Schwab <[email protected]> wrote: > Put in quotes and commas to create a CSV file is your best bet. Then > open in excel and save as an excel format. > "field one ","field two ",123456789.12,"field three" > Probably would be better to even put quotes around the number fields. > > On Tue, Sep 3, 2019 at 1:13 AM Peter <[email protected]> wrote: > > > > Hi Group > > > > I have been using txt2pdf for a long and I understand it also does > building > > CSV files which can be opened using Excel. Is there a way to convert a > text > > file into Excel automatically within mainframe as > > .XLS prior sending to email server ? > > > > Peter > > > > ---------------------------------------------------------------------- > > For IBM-MAIN subscribe / signoff / archive access instructions, > > send email to [email protected] with the message: INFO IBM-MAIN > > > > -- > Mike A Schwab, Springfield IL USA > Where do Forest Rangers go to get away from it all? > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
