E
ElliottJones
Hello,
I've created a simple worksheet that contains a date & time in one of
the coloumns. The format of the text string in "M/D/Yyyy h:mm AM/PM"
e.g. "4/3/2003 5:36 PM", "8/14/2003 4:56 AM". I'm trying to convert the
text string into a UK date format thus the above examples would then
read..."3/4/2003 5:36 PM", "14/8/2003 4:56 AM". As the original text
string is created by running a macro, which opens a text file and puts
all the data into certain columns etc) I would like the date reformat
be done as part of this. I'd appreciate help with the code, as I'm
having no joy with the various date functions and can't believe it
would be down to a character by character check of the original string
(further complicated by a possible one or two digit day and month)
Thanks.
I've created a simple worksheet that contains a date & time in one of
the coloumns. The format of the text string in "M/D/Yyyy h:mm AM/PM"
e.g. "4/3/2003 5:36 PM", "8/14/2003 4:56 AM". I'm trying to convert the
text string into a UK date format thus the above examples would then
read..."3/4/2003 5:36 PM", "14/8/2003 4:56 AM". As the original text
string is created by running a macro, which opens a text file and puts
all the data into certain columns etc) I would like the date reformat
be done as part of this. I'd appreciate help with the code, as I'm
having no joy with the various date functions and can't believe it
would be down to a character by character check of the original string
(further complicated by a possible one or two digit day and month)
Thanks.