Help!
My boss asked me to convert a bunch of dates on a text file that looks like this:
20040820 into something more common, like 08/20/2004.
I have opened it in excel thinking it would make quick work out of it but no dice.
I also been frantically searching all over the net for the past hour for a solution. A lot of samples come close but still no cigar. You guys are my last ray of hope. Any help would be greatly appreciated.
Thanks.
My boss asked me to convert a bunch of dates on a text file that looks like this:
20040820 into something more common, like 08/20/2004.
I have opened it in excel thinking it would make quick work out of it but no dice.
I also been frantically searching all over the net for the past hour for a solution. A lot of samples come close but still no cigar. You guys are my last ray of hope. Any help would be greatly appreciated.
Thanks.