Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I'm needing help with a CSV file that is to be transferred from Excel. There are two (2) columns - one with a MMMYYYY (Dec2006) format and the other with a XX-XX format (01-41). The problem is when I open the CSV file, the MMM column comes out as MMM-YY (Dec-06) and the XX coumn comes out as MMM-YY (Jan-41). I have saved the format as Custom for the first column and the second as a text but they still come out the way described. Is there anything I need to change in the default values to prevent this from happening? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Export XML | Excel Worksheet Functions | |||
Deleting data in a table from excel export | Excel Discussion (Misc queries) | |||
Can't export actual text - Get #### instead | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions |