Pol,

Not certain what is causing this in 2007, but you can standardize those
dates in another column using the text function.
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474



"pol" wrote:

Hai all,

When I am opening a dbf file through excel 2007 the datcolumn shows as
follows. But there is no problem while opening through old version . How I
can solve this problem in 2007 excel

Date

20080118
20080118
20080118
20080125
20080125
20080125
20080125
02/12/2008
02/12/2008
02/12/2008
02/12/2008
02/12/2008
20080214
20080214
20080214
20080214
04/04/2008
04/04/2008
04/04/2008
04/04/2008
20081017
20081017
20081017

With thanks and regards

Pol