Excel query

I have a lot of CSV files (all with the same structure) to import into Excel and I need to set the data format to Text, Date etc as appropriate. There are 24 columns and it's a bit fiddly to do it manually each time in the Import Wizard. Any suggestions? I'm using Excel 2003. Cheers!