CSV Export Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
How about renaming the .csv file to .txt?

Then when you open that .txt file, you'll be able to specify how you want each
field treated (in the text import wizard).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some Cells display text others dates in the same column 2
Date Format - US to English 6
need a macro to copy the data to the following cells 10
date format - excluding year 2
sort by month out of sequence 4
How to Export Gmail Emails to PST Format? 4
conditional formating dates, please help me 1
organising dates in pivot table column 2

Back
Top