OK, here's a POSSIBLE solution:
Since the format of the source data does not match the current system date
format,Excel converts any source value that COULD be a date to an Excel date,
which is a number.
Any non-valid date is loaded as text.
So, we can either import the data as text and convert,o
Mandeep:
I think the problem is that his default date format is different from our
own.(and HIS default date format is different than the source date format)
I suspect his original date records are sequential:10-Oct-2015
12-Oct-2015
14-Oct-2015
16-Oct-2015
18-Oct-2015
22-Oct-2015
24-Oct-2015
26-Oc
I will try that when I get home tonight.
Thanks Paul.
On Monday, 23 November 2015 08:12:27 UTC-5, Paul Schreiner wrote:
>
> You said:
> DATE1 = Source. It always gets imported in as 2 different date formats.
>
> I SUSPECT that your source data has a date in a specific format like:
>
> mm/dd/yy
>
You said:DATE1 = Source. It always gets imported in as 2 different date formats.
I SUSPECT that your source data has a date in a specific format like:
mm/dd/yy
but your Windows Regional settings are set to a date format that is something
else.Like:dd/mm/yy
So, when you read in values, if the value
