|
date format problem from opening dbf file in excel 2007
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 |
date format problem from opening dbf file in excel 2007
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 |
date format problem from opening dbf file in excel 2007
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 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 |
date format problem from opening dbf file in excel 2007
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 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 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 - |
date format problem from opening dbf file in excel 2007
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 |
date format problem from opening dbf file in excel 2007
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" 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 |
| All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com