Posted 8/26/2009 13:34 (#825120 - in reply to #825116) Subject: Re: Excel Date Format: Converting UK to US
Ashburn, GA, (very close to Heaven!)
Philbert - 8/26/2009 13:31 Right click choose format,date, and change the location to US. It works that way in 2003 Excel.
Yes it will if you enter the date FROM the beginning. However, if you are dealing with a UK date format column on a sheet originating from an ASCII file, the conversion is not that simple.