Excel 2000 255 character limit

I have data that I need to import into Excel, then export
to .prn (because .prn is the only text format that seems
to be able to save formatting) and when I do the last 5
digits are not in the correct area, they are moved to the
bottom of the file. I've done some research and I think
this is the 240/255 character limit in Excel. Is there any
way around this other than coding a macro to format the
data? Maybe a registry setting?

240 characters is when .prn files wrap.

One way is to use a formula to concatenate your cells in each row into a nicely
spaced string.

Another way is to use a macro.

Here's a post that describes both ways of dealing with a fixedwidth file.
http://groups.google.com/groups?thre...48D8%40msn.com

Shannon wrote:

I have data that I need to import into Excel, then export
to .prn (because .prn is the only text format that seems
to be able to save formatting) and when I do the last 5
digits are not in the correct area, they are moved to the
bottom of the file. I've done some research and I think
this is the 240/255 character limit in Excel. Is there any
way around this other than coding a macro to format the
data? Maybe a registry setting?

--

Dave Peterson