If you save as a .prn file, excel will use the column widths to pad (or
truncate!) the values.
Maybe you could adjust the columnwidths to be what you want before you save.
I'd change the font to Courier New (a non-proportional font) to make it a bit
You may be able to use a formula in a helper cell in each row:
=left(a1,3) & " " & text(b1,"00" & " " & ....
Then copy that formula down the column (after you have it perfekt!). Then copy
that column, paste into Notepad and save from there.
You could hide that column so that it's always available, but not too
Or you could use a macro and write code and have complete control over what you
Here are three sites that you could steal some code from:
Earl Kiosterud's Text Write program:
(or directly: http://www.yqcomputer.com/
Take a look at Earl's program. It may do what you want.