bugshaw: (BugCount)

Excel query

posted by [personal profile] bugshaw at 02:59pm on 11/09/2009
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!
There are 14 comments on this entry. (Reply.)

April

SunMonTueWedThuFriSat
    1
 
 2
 
 3
 
 4
 
 5
 
6
 
 7
 
 8
 
 9
 
 10
 
 11
 
 12
 
13
 
 14
 
 15
 
 16
 
 17
 
 18
 
 19
 
20
 
 21
 
 22
 
 23
 
 24
 
 25
1
 26
 
27
 
 28
 
 29
 
 30