If you rename the .csv file to .txt, you may be able to import the file quicker
by setting each field the way you want.

Then you could format the numeric fields as percentages or whatever you needed.

If you have fields that have implicit decimals, you could import them as
Generals and then put a factor of 10 (10, 100, 1000, ...) in an empty cell.
Edit|copy, edit|paste special|Values and divide (all in code) to convert that
field.

Paul H wrote:

I have an empty, formatted spreadsheet, that I created by writing a few rows
into it from my COBOL program, field by field, then deleting all of the
rows.

The process of creating the entire XLS or XLSX runs much too slow (100
records per minute or less), and uses memory up, so can never allow me to
finish converting some of my large CSV files into formatted XLS (Excel 2003)
or XLSX (Excel 2007) files. Someone told me to "turn off continual
re-calculating". How?

I wonder if I can somehow import my large .CSV file into my .XLS empty
formatted file? I cannot find a way. Any help would be appreciated.

TIA, Paul

--

Dave Peterson