I am reading data in from a number of excel files, and putting it all in one file, and am having problems with dates. The format in the original files is dd/mm/yyyy hh:mm, the format in the destination file is the same, but when I read a cell with a date, eg 01/11/2008, it is getting read as 11/01/2008 before I even do anything with it. ie, I read in the value, and when i do debug,print, or msgbox, the value at runtime is 11/01/2008. This is really confusing me and there doesnt seem to be any way around it. format() doesnt help. Any ideas on whats going on here?