Mike H wrote:
Dates in Excel are numbers and the number 101408 is August 22 2077 ...
2177 , not 2077 ?
...so
Excel is doing exactly what your telling it to do. Without resorting
to VB I don't know of any way to make it recognise that number as the
date you believe it is. ...
Data/ Text to Columns, Mike.
--
David Biddulph