Hi There,

I have a text file that i import which has about 100 or so lines like
below.
"16","1/06/2004 9:39:19 AM","
"17","17/06/2004 12:29:14 PM",

When i use the "cells(row,col).value" function to insert the date, the
date is reversed for ALL dates that are not in the format dd/mm/yyyy.
Eg For every month of every year, the 1st through to the 9th days are
written backward since the format is d/mm/yyyy and i cannot modify this
text file.

Even when debugging and hardcoding the value to a cell i find this
problem:
eg
Code:
--------------------
Cells(3, 10).Value = "1/06/2004 9:39:19 AM"
-Cells(3, 10).Value = DateValue(Cells(3, 10).Value)-
--------------------

And the output is "6/01/2004" without any timestamp and date reversed
(with or without the DAtevalue conversion)

But this double digit date works

Code:
--------------------
Cells(3, 10).Value = "*11*/06/2004 9:39:19 AM"
--------------------
=11/06/2004 9:39:19 AM



Whats going on here?? (the format of the column i am retrieving all
the info and saving to is of the format "Date: *14/03/2001" .


--
tarns
------------------------------------------------------------------------
tarns's Profile: http://www.excelforum.com/member.php...o&userid=32291
View this thread: http://www.excelforum.com/showthread...hreadid=529905