problem with date set up

[Tim]

Hi i download a merchant credit card transaction list. The credit card
expirery date is originally Month/year.

when it is imported it turns out as day/month/current year.

I can not convert this back, if I put in format month year, it just converts
the last 2 figures ie month /current year..

Any ideas thanks Tim

 

[Guest]

Hi

Try using Data/Text to columns.
Select the column and click on Data / Text to columns. On the first two
dialog boxes, click next. On the third dialog option box, in the top right
corner, tell Excel that the column is a date and the format of that date.
Job done! Make sure you take a copy before you start.

Hope this helps.
Andy.

 

[Dave Peterson]

I don't know how you download your data, but you may want to try this:

Save the download into a plain old text file (*.txt).

Then when you open that text file in excel, you'll be prompted to describe each
field. You'll be able to choose Text for that field with the expiration date.
So excel won't change it to a date.