R
Rich Locus
Group:
I'm sure this questions has been asked, but I didn't find it when searching
for date issues. I have a spreadsheet with a column formatted as Date. When
I save the worksheet as a text tab-delimited file, Excel converts the date
to the numeric format (i.e. 37185). Then, when I try to import the text file
into Access, Access won't accept the number as a date, and rejects every
record. Other than changing the Excel column to a Text format, is there any
other way to tell Excel to export a date formatted column with the usual
MM/DD/YYYY format instead of a number?
Thanks,
I'm sure this questions has been asked, but I didn't find it when searching
for date issues. I have a spreadsheet with a column formatted as Date. When
I save the worksheet as a text tab-delimited file, Excel converts the date
to the numeric format (i.e. 37185). Then, when I try to import the text file
into Access, Access won't accept the number as a date, and rejects every
record. Other than changing the Excel column to a Text format, is there any
other way to tell Excel to export a date formatted column with the usual
MM/DD/YYYY format instead of a number?
Thanks,