Fixed Column Width

C

Carlo

Hi
I have an Excel spreadsheet that ultimately I need to save as a plain
text file but with specific column widths in the text file. (I have
tried changing the width in Excel and then saving it as Text (DOS
format) but it does not seem to be correct. Unless the width in Excel
is in a format other that characters ie. if the excel width is set to
15 does it mean it is 15 characters in length or something else)

Thanks
Carlob1
 
J

JE McGimpsey

Column width in XL is in the number of numeric characters in your
standard font, so a width of 15 will accommodate 15 zeros, but if your
font is proportional, may allow many more "i"s.

in any case, if you'll either need to pad each of your output cells or
use a macro.
 
Top