When I open my data file (originally in .dbf format, in excel, the date field in some cell is normal i.e. dd/mm/yyyy but in many it chages to yyyymmdd (without even the slash-"/". Such misformated cells rows are approximately 40-45% out of total rows. Because of this trouble I can not use the converted file in excel. The original data file is generated through a accounting software being used since more than 20 years and have never encountered any mistake while using in dbase.
Bookmarks