B
BernieH
I have a *.CSV file with a column of dates in various formats, such as -
1/01/1900
1/07/1901
1/06/1903
1880
1901
1904
1911
1911
1913
1/05/2004
Winter 2004
I need to get these dates into YYYYMMDD or YYYY format (depending on how
much info is available, e.g. 1911 is OK left as 1911). Formatting the cells
as custom YYYYMMDD however doesn't work, as ?pre-1900 dates get converted
wrongly.
There are ~20K lines in the file, so any solution has to be pretty much
automatic.
Your help would be very much appreciated!
TIA
bernieh
1/01/1900
1/07/1901
1/06/1903
1880
1901
1904
1911
1911
1913
1/05/2004
Winter 2004
I need to get these dates into YYYYMMDD or YYYY format (depending on how
much info is available, e.g. 1911 is OK left as 1911). Formatting the cells
as custom YYYYMMDD however doesn't work, as ?pre-1900 dates get converted
wrongly.
There are ~20K lines in the file, so any solution has to be pretty much
automatic.
Your help would be very much appreciated!
TIA
bernieh