>Hi everybody,
>
>If I place text into first column, then select text to cells and follow the steps, it automatically uses "General" format and I had to click on each cell to change it to text.
>
>Is there a way to automatically make Excel always chose text option when doing this operation for all columns and not use 'General' ?
>
>Thanks in advance.

Just a SWAG: Unless you don't depend on finished cells for next cells (as in reading part from it), as general rule I'd first enter data and afterwards try to format blocks in the needed way. Much safer than formating in advance and then something goes haywire... If it really needs to be done on cell level, define border cells and try looping through columns and rows in script.

my 0.02€
thomas