I'm so sorry to be a pain but if someone could take a look at this problem for me I would be eternally grateful as it is driving me mad, slowly.
Contained in Module 7 is a text to column action for cells N3 to N500 on the "DATES" sheet.
It works fine for most of the data but the data in N16-N17, N34-N35 and N39-41 are formatted slighty differently and the command always puts the month first instead of the day (it is American).
For example N38 is 2/18/2005 and after action is 2 18 2005
However N39 is 03/01/2005 and after action is 1 3 2005 when it should be 3 1 2005.
I am aware that the data is formatted slighty different to the rest and is thus giving me problems but for the life of me I am unable to understand why.
Any help is very gratefully received.