setting column width
 

I have a spreadsheet that I am using as a template, that I save out as a .prn
file to bring it into my Linux environment that I use to load into another
application.

I need to set my columns to a certain width in characters for loading
purposes. Below are the details:
Start End
column A = 1 50
Column B = 52 52
Column c = 54 63
Column D = 65 74

If I can set my template up to have these column widths to start it would
make it very easy as I save out to a .prn file. I am just unsure how to
translate the width to character values.

Thanks,

setting column width
 

Would depend upon font type and size.

Proportional or non-proportional font........Arial would take up less width than
Courier for example.

The number that appears in the Standard column width box is the average number
of digits 0-9 of the standard font.

Also, I am not sure what Start and End signifies...........number of characters
or?


Gord Dibben MS Excel MVP

On Thu, 10 Jul 2008 14:09:00 -0700, James
wrote:

I have a spreadsheet that I am using as a template, that I save out as a .prn
file to bring it into my Linux environment that I use to load into another
application.

I need to set my columns to a certain width in characters for loading
purposes. Below are the details:
Start End
column A = 1 50
Column B = 52 52
Column c = 54 63
Column D = 65 74

If I can set my template up to have these column widths to start it would
make it very easy as I save out to a .prn file. I am just unsure how to
translate the width to character values.

Thanks,