D
Dianna
When exporting from a 97 database to excel 2003,
formatting of date column is lost. Any suggestions?
formatting of date column is lost. Any suggestions?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
Harlan Grove
Dianna said:When exporting from a 97 database to excel 2003,
formatting of date column is lost. Any suggestions?
What do you mean by 'exporting'? Excel 2003 reads Excel 97 .XLS workbooks
directly. Are you opening an .XLS workbook last saved using Excel 97 in
Excel 2003? What was the Excel 97 date format?
D
Dave Peterson
Any chance that the windows date format changed and xl was using your windows
date format in both pc's?
(This question makes a lot more sense if you have xl97 on one pc and xl2003 on
another?)
Windows start button|settings|Control panel|Regional settings Applet|Date tab
is how I would check my windows date format in win98.
date format in both pc's?
(This question makes a lot more sense if you have xl97 on one pc and xl2003 on
another?)
Windows start button|settings|Control panel|Regional settings Applet|Date tab
is how I would check my windows date format in win98.
D
Dianna
-----Original Message-----
What do you mean by 'exporting'? Excel 2003 reads Excel 97 .XLS workbooks
directly. Are you opening an .XLS workbook last saved using Excel 97 in
Excel 2003? What was the Excel 97 date format?
I am exporting an Access 97 database into an Excel 2003 worksheet.