exporting 97 to 2003

  • Thread starter Thread starter Dianna
  • Start date Start date
D

Dianna

When exporting from a 97 database to excel 2003,
formatting of date column is lost. Any suggestions?
 
Dianna said:
When exporting from a 97 database to excel 2003,
formatting of date column is lost. Any suggestions?
Click to expand...

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?
 
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.
 
-----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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Excel 2007 crashes when perform SAVE AS to Excel 97-2003 0
Save As 97-2003 workbook 1
Best Gmail Backup Tool to use in 2025? 3
Export data from SQL into Excel files 2
How to Convert EML to PST? 2
working with excel 97 workbooks 5
Excel open NOT in compatability mode 2

Back
Top