Changing text field to a date field.

  • Thread starter Thread starter juliet
  • Start date Start date
J

juliet

Please help me Im going nuts. I have exported a number field into excel
as a text field and I need to convert them to a date field so I can
sort them. The field displays as 0607 month and year for credit card
expiry dates. I cant for the life of me work out how I can convert it
to mmyy so I can sort them. Any help or if you can direct me somewhere.
Surely it cant be THAT hard???
 
juliet said:
Please help me Im going nuts. I have exported a number field into
excel as a text field and I need to convert them to a date field so I
can sort them. The field displays as 0607 month and year for credit
card expiry dates. I cant for the life of me work out how I can
convert it to mmyy so I can sort them. Any help or if you can direct
me somewhere. Surely it cant be THAT hard???
Click to expand...

Do you want to convert them and sort them in Excel? If so I suggest
that an Excel newsgroup would be the place to ask.
 
Try this formula in an adjacent cell
Left(yourcell,2)&"/"& right(yourcell,2)&"/"&yearcell
HTH
 

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

Text type date change to date type date 2
Access Microsoft Access Calculated Field - Expiry Date 0
expiry date e.g mm/yyyy 1
Splitting fields in access 2010 0
Convert Text To Valid Date 4
Change Data from 19860701 (text) to 07/01/1986 (date) 10
Changing a text field to a date field 7
How can you format a date/time datatype to read month and year? 1

Back
Top