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,
|