exported date field not recognized as date in Excel...Help!

On 2002-11-27 00:06, sawgee2001 wrote:
When I export a date field from my payroll database into Excel, Excel does not recognize the data as a "date". For example, January 15, 1976 would be entered into the our payroll software as 01/15/1976, and when this field is exported into Excel, it appears as 01/15/1976. However, when I try to sort on the column of exported data to create a list based on seniority, it sorts based on the data from the left, not by the year. I've checked the regional settings, and it is set as "mm/dd/yyyy". I've tried to format the column, using a custom date format, but this does not seem to change anything. Any ideas out there?
This message was edited by sawgee2001 on 2002-11-27 00:06

Click to expand...

AmpersanderAsterisk said:

great tip. I had this same problem and your solution saved me a ton of time. Thanks.

Click to expand...

Aladin Akyurek said:

Let A1 house an imported date.

If

=ISNUMBER(A1)

results in FALSE, do the following...

(1.) Copy an empty cell.
(2.) Select the range of imported dates.
(3.) Activate Edit|Paste Special >Add.
(4.) Format the date range as date.

Click to expand...

adam.ward said:

Awesome, thanks for this... This very situation has driven me nuts for a while.

Click to expand...

chinatowngal said:

Hi Aladin ;

I know u explained quite well.
But I still dont get to know it.
I have tried same thing but still encounter the problem for date format.
Can u explain more details ?

Click to expand...

Aladin Akyurek said:

If you did try out the instructions and the desired results did not obtain, you could try ASAP Utilities fro asap-utilities.com.

Click to expand...