I have a list of data in excel with the data arranged in rows, the data is a mix of text, numbers and dates. When i open the file and examine the data everything is fine.
Now the problem ... I want to move this worksheet on to a new sheet in an existing workbook, i use the edit >>>> move/copy sheet and the sheet is moved but when i examine the data the date format is inconsitent.
In my source sheet the date is formated dd/mm/yy but when i move it across it is a mix of dd/mm/yy and mm/dd/yy. What appears to be happening is that for dates with dd less than 12 it reverts to mm/dd format.
eg in my source sheet 01/07/05 (1st July) becomes 07/01/05 (7th Jan) but 17/06/05 (17th June) remains in that format.
There are too many cells affected to change each one individually and i cant find anyway of making any format the default for a workbook.
Now the problem ... I want to move this worksheet on to a new sheet in an existing workbook, i use the edit >>>> move/copy sheet and the sheet is moved but when i examine the data the date format is inconsitent.
In my source sheet the date is formated dd/mm/yy but when i move it across it is a mix of dd/mm/yy and mm/dd/yy. What appears to be happening is that for dates with dd less than 12 it reverts to mm/dd format.
eg in my source sheet 01/07/05 (1st July) becomes 07/01/05 (7th Jan) but 17/06/05 (17th June) remains in that format.
There are too many cells affected to change each one individually and i cant find anyway of making any format the default for a workbook.