Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: wheres menu item to change file format conversion options?
Where in the Excel menus is the menu item to allow changing options for the
file format converters? For example, to change the maximum line length for the ".prn" file converter. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: wheres menu item to change file format conversion options?
When you're saving a file as .prn???
If yes, then there is no setting to extend past 240 characters per line. Saved from a previous post: There's a limit of 240 characters per line when you save as .prn files. You have a few choices (try against a copy of your worksheet): I'd either concatenate the cell values into another column: =LEFT(A1&REPT(" ",5),5) & LEFT(B1&REPT(" ",4),4) & TEXT(C1,"000,000.00") (You'll have to modify it to match what you want.) Then I'd copy and paste to notepad and save from there. Once I figured out that ugly formula, I kept it and just unhide that column when I wanted to export the data. If that doesn't work for you, maybe you could do it with a macro. Here's a link that provides a macro: http://google.com/groups?threadm=015...0a% 40phx.gbl Serge wrote: Where in the Excel menus is the menu item to allow changing options for the file format converters? For example, to change the maximum line length for the ".prn" file converter. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel updating from XML file - file path specific? | Excel Discussion (Misc queries) | |||
Opening an Excel file | Excel Discussion (Misc queries) | |||
EXCEL Workbook tab format options: change color or font | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) |