| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File always opens with Date format set - Excel 2007 | Excel Discussion (Misc queries) | |||
| Problem opening Excel 2007 files | Excel Discussion (Misc queries) | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Excel 2007 File Problems (Opening New Format) | Excel Discussion (Misc queries) | |||
| Opening a csv file with US date format on a Australian PC | Excel Discussion (Misc queries) | |||
Linear Mode
