| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Line lenght limit while saving as a PRN file
Hi,
Anyone's aware of any problem regarding a maximum number of character per line when saving an excel spreadsheet as a PRN file. We currently have an excel sheet that has way over 250 characters in length but when saving as a PRN and then re-open the file in notepad(or even Word), it is being cut at 234 characters. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line lenght limit while saving as a PRN file
Why save as prn? There is not a problem with PRN character lenght, it
just has a 240 character line lenght specification. Formatted text (.prn) is limited to 240 characters per line in Excel http://support.microsoft.com/kb/249885 Patrick wrote: Hi, Anyone's aware of any problem regarding a maximum number of character per line when saving an excel spreadsheet as a PRN file. We currently have an excel sheet that has way over 250 characters in length but when saving as a PRN and then re-open the file in notepad(or even Word), it is being cut at 234 characters. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line lenght limit while saving as a PRN file
Unless you have an alternate way to save an excel file as text and respect
the width of each columns, which the dedicated and only way to do this(as far as I know) is to save as PRN "Bob I" wrote: Why save as prn? There is not a problem with PRN character lenght, it just has a 240 character line lenght specification. Formatted text (.prn) is limited to 240 characters per line in Excel http://support.microsoft.com/kb/249885 Patrick wrote: Hi, Anyone's aware of any problem regarding a maximum number of character per line when saving an excel spreadsheet as a PRN file. We currently have an excel sheet that has way over 250 characters in length but when saving as a PRN and then re-open the file in notepad(or even Word), it is being cut at 234 characters. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line lenght limit while saving as a PRN file
You can use a non-proportional font like Courier and adjust the column
widths as required and then save as a .txt file. Hope this helps. Pete On Oct 26, 8:43 pm, Patrick wrote: Unless you have an alternate way to save an excel file as text and respect the width of each columns, which the dedicated and only way to do this(as far as I know) is to save as PRN "Bob I" wrote: Why save as prn? There is not a problem with PRN character lenght, it just has a 240 character line lenght specification. Formatted text (.prn) is limited to 240 characters per line in Excel http://support.microsoft.com/kb/249885 Patrick wrote: Hi, Anyone's aware of any problem regarding a maximum number of character per line when saving an excel spreadsheet as a PRN file. We currently have an excel sheet that has way over 250 characters in length but when saving as a PRN and then re-open the file in notepad(or even Word), it is being cut at 234 characters. Thanks - Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Line lenght limit while saving as a PRN file
Then you may have to reduce the character count, or pad with spaces and
save as csv. Patrick wrote: Unless you have an alternate way to save an excel file as text and respect the width of each columns, which the dedicated and only way to do this(as far as I know) is to save as PRN "Bob I" wrote: Why save as prn? There is not a problem with PRN character lenght, it just has a 240 character line lenght specification. Formatted text (.prn) is limited to 240 characters per line in Excel http://support.microsoft.com/kb/249885 Patrick wrote: Hi, Anyone's aware of any problem regarding a maximum number of character per line when saving an excel spreadsheet as a PRN file. We currently have an excel sheet that has way over 250 characters in length but when saving as a PRN and then re-open the file in notepad(or even Word), it is being cut at 234 characters. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a limit line | Charts and Charting in Excel | |||
| Set Limit for Line Graph | Excel Discussion (Misc queries) | |||
| Limit trend line to last 12 records | Charts and Charting in Excel | |||
| How do I add a limit line to a chart, so I can see where a data p. | Charts and Charting in Excel | |||
| Any way to get around the 240-character line limit on text output? | Excel Discussion (Misc queries) | |||
Linear Mode
