Need Help With Importing DBF File

[CARBOB]

I have approx. 35 files that I have imported with DBF format. The problem I have is when I attempt to sort the dates sort but not the values. I think the values are in text format but I reformatted the column to numbers, still not working. Thanks for help.
Carbob

ALLSTATES CASH 3.xls
	A	B	C	D	E
1	DRAWDATE	P1	P2	P3
2	01/28/1997	0	1	1	011
3	01/29/1997	9	2	6	926
4	01/30/1997	2	0	1	201
5	01/31/1997	2	0	6	206
6	02/01/1997	9	8	0	980
Fl31

 

[sbeatton]

Did you try reformatting them to DATE format?

 

[Andrew Poulsom]

It's not clear from your example what the problem is because all the dates are unique.

If you want to sort all the data by date, select it all before sorting.

You can quickly convert text that liiks like a number to a real number by clicking the column header, choosing Data|Text to Columns and clicking Finish. Changing the Format won't change the cell contents, only how it looks.

 

[Norie]

Is it the column with the dates that's the problem.

If so try this:

Select the column with the dates.

Goto Data>Text to columns...

On the 3rd step chose Date for Column data format and MDY from the dropdown.

That should change them to true date values.

 

[CARBOB]

Andrew, your suggestion worked. Norie, sbeatton thanks for responding.

Carbob