Changing text field to a date field.

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???
 
T

tony

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

Email notifications without opening application 1
VBA - exporting serial letters to single documents 0
expiry date e.g mm/yyyy 1
exporting report fields to spreadsheet 1
Text type date change to date type date 2
Convert Text To Valid Date 4
Change Data from 19860701 (text) to 07/01/1986 (date) 10
Automation of scanned file storage based on content 0

Top