Posted 8/26/2009 14:33 (#825179 - in reply to #825127) Subject: Re: Excel Date Format: Converting UK to US
Ashburn, GA, (very close to Heaven!)
"General" when first opened from ASCII file. If I convert to "DATE", it's like it will not recognize the UK date version as date once opened the first time.
I jumped through some hoops and came up with a work around, but it was tedious. I had about 700 records, and while I did not come with an automated shortcut, I got it sorted like I wanted.