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

If you don't have an account you can create one now.
HTML doesn't work in the subject.
More info about formatting
 
Notice: This account is set to log the IP addresses of everyone who comments.
Links will be displayed as unclickable URLs to help prevent spam.

September

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