Hi Paul,
Not certain what changed, but I set my system date as yours (M/D/) and
everything is miraculously back to normal.
Thanks.
On Monday, 22 February 2016 14:51:28 UTC-5, Paul Schreiner wrote:
>
> Your earlier description/expectation seems faulty:
> Looking at the .csv file, the fir
Your earlier description/expectation seems faulty:Looking at the .csv file, the
first 26 records are CLEARLY not between October 2015 and February 2016.the
rest seem to be in month/day/year format:2001-02-16
2001-04-16
2001-06-16
2001-08-16
2001-10-16
2001-12-16
2002-02-16
2002-04-16
2002-06-16
2
I understand Paul. PSA csv file.
Thanks.
On Monday, 22 February 2016 08:40:54 UTC-5, Paul Schreiner wrote:
>
> It'll be difficult to guess the issue without seeing the original
> (unconverted) data.
> Can you try importing it as "text" or even saving it as an ASCII file
> without ever bringin
It'll be difficult to guess the issue without seeing the original (unconverted)
data.Can you try importing it as "text" or even saving it as an ASCII file
without ever bringing it to Excel?
Also, the problem is that what *I* see when I open the file may not be what YOU
see.since my7 default date
PSA.
Cannot figure out how to fix this or change settings so that the date is
consistent.
The dates on attached are downloaded from the web. Once imported, they
change format.
The dates in this should be between Oct 2015 and Feb 2016.
I have tried various system and excel date settings - no