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

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
(E-Mail Removed)
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

Please let me know how to use text function to solve this problem

With thanks
Pol

"galimi" wrote:

> 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
> (E-Mail Removed)
> 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

Assuming your "dates" are in column D, starting in D2, then you can
put this formula in an adjacent column on row 2:

=IF(D2<40000,D2,DATE(LEFT(D2,4),MID(D2,5,2),RIGHT(D2,2)))

Format the cell as a date in the style you prefer, and then copy down.

Hope this helps.

Pete

On Nov 28, 4:36*pm, pol <p...@discussions.microsoft.com> wrote:
> Please let me know how to use text function to solve this problem
>
> With thanks
> Pol
>
>
>
> "galimi" wrote:
> > 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
> > e...@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- Hide quoted text -
>
> - Show quoted text -

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" <(E-Mail Removed)> wrote in message news:BB9646B3-6F9D-4430-BD87-(E-Mail Removed)...
> 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

Thanks it was helpful to me

thanks a lot

"macropod" wrote:

> 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" <(E-Mail Removed)> wrote in message news:BB9646B3-6F9D-4430-BD87-(E-Mail Removed)...
> > 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
>