View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
 
Posts: 542
Default 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,