Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi:
I've created a text file from an Excel sheet that ouputs range cell data to a .csv. One of the fields is a time-datestamp. The file then has a field in the format #2000-04-06 10:15:00#. (Used simple Write #n statement to generate output lines) When I either read the .csv directly with Excel, or open/import and use Excel to id the field, it doesn't convert to date, even tho I specify YMD on input -- it still has the format in the cell #2000-04-06 10:15:00# . I know I've seen somewhere how to fix this, I just can't remember where, and can't find it here. I think this is the Microsoft Access database date format for import. Thanks in advance for any clues. -- Roy Zider |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I format date field in footer? | New Users to Excel | |||
How do I change the date format when importing a txt file? | Excel Worksheet Functions | |||
How do I format currency field in Excel 2000 w/o 2 extra zeroes? | Excel Discussion (Misc queries) | |||
Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Importing from SQL changes date format | Excel Programming |