Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a large (12,000 rows) EXCEL 2003 worksheet with a column of birthday
dates in the format "24-Mar-52." The EXCEL file is not importing correctly into Outlook 2003 Contacts, perhaps of the large size of the EXCEL file. The conversion process just hangs and then freezes. However, when I save the EXCEL file as a CSV file, it imports correctly. However, although the birthday dates appear identical in the resulting CSV file, when I import that file into Outlook Contacts, the resulting birthday dates show as "None." My hunch is that in converting from EXCEL to CSV, I am losing the date format somehow. I suspect I need to use the "Values" function somehow, which I tried, but it did not work. How can I retain the dates in the EXCEL column in the conversion to CSV, and then in the subsequent import into Outlook Contacts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel date conversion-UK to US | Excel Worksheet Functions | |||
Losing fields after CSV conversion | Excel Discussion (Misc queries) | |||
Concatenating a Text and a Date without losing orginal Date Format | Excel Discussion (Misc queries) | |||
Turning off Date Conversion in Excel | Excel Discussion (Misc queries) | |||
concatenating "00"&"00"&"01" without losing the zero values | Excel Worksheet Functions |