Hi pol,

Assuming the data start in D2, try:
=IF(LEFT(CELL("format",D2),1)="D",D2,DATE(LEFT(D2, 4),MID(D2,5,2),RIGHT(D2,2)))
Format the cell as a date, then copy down.
--
Cheers
macropod
[MVP - Microsoft Word]


"pol" wrote in message ...
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