date default format/acess to excel conversion

[Diann]

When creating a .csv file from an Access table, the dates
in the subsequent Excel spreadsheet are in the date+time
(5/31/02 00:00) format even though the field in Access is
set to short date (5/31/02). Is there a way in Excel to
set the default date format to the short date?

 

[Guest]

You could manually set it in the spreadsheet by selecting the column, Select Format then the Cells option
Select the Number tab, then a list of number styles should appear
Select date then a list of possible formats will appear to the right of the list

If you are creating it from Access, it may well be that the table format for the date is different to the user interface format. That can be changed on the table and I'd guess that would present the date correctly.

 

[Guest]

-----Original Message-----
You could manually set it in the spreadsheet by selecting

the column, Select Format then the Cells option.

Select the Number tab, then a list of number styles should appear.
Select date then a list of possible formats will appear

to the right of the list.

.....Yes, I could do that but it's what I'm trying to avoid
since I'm setting this up for someone who only knows how
to point and click at menu buttons.

If you are creating it from Access, it may well be that

the table format for the date is different to the user
interface format. That can be changed on the table and
I'd guess that would present the date correctly.

.

.....no, the date in the Access table is set to short date
but is converting to the date+time format in Excel.

good try, though