I have a report that I am outputting into Excel. There is a TXT field in my report and when I output to Excel (using ON TABLE SET ONLINE-FMT EXL2K), the TXT field falls into several different cells instead of just one.

The result is that I have a 9000+ row report in Excel instead a 2800 row report, which is what its supposed to be.

Any suggestions on how to keep the TXT field in one cell?


WF 5.3.3 Windows 2000

It depends on the data source, but usually I change TX fields (in Master file) to A2000, or something.

I cannot change the format in the Master File -- I do not have that autohority.

I've never had much luck with defining a format change in a TXT field. Any suggestions on how to do that?