Need Help With Importing DBF File

CARBOB

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
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
ABCDE
1DRAWDATEP1P2P3
201/28/1997011011
301/29/1997926926
401/30/1997201201
501/31/1997206206
602/01/1997980980
Fl31
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Well-known Member
Joined
Apr 28, 2004
Messages
76,047
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Jun 6, 2005
Messages
1,860
Andrew, your suggestion worked. Norie, sbeatton thanks for responding.

Carbob
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,010
Members
412,304
Latest member
citrus
Top