I'm currently working with a lot of comma separated value (.CSV) files.
Whenever these files are opened in Excel (2000), since all size
information is not present, each cell is given the same tiny size.

What I need is either
1. An option that says "automatically fit cell sizes to contents upon
file opening", or

2. A method of fitting cell sizes to contents that is quicker and less
tedious than double-clicking at the top of each column (since there are
40 or so columns in each spreadsheet).

Before you ask, no I can't just save the files in .XLS format, they
need to stay as .CSV files for compatibility with other software.

Do either of my options exist?

Thanks in advance for your response,
Richie.


--
cornelius1729
------------------------------------------------------------------------
cornelius1729's Profile: http://www.excelforum.com/member.php...o&userid=36749
View this thread: http://www.excelforum.com/showthread...hreadid=564690