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 wrote:
> 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???

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.


--
Joseph Meehan

Dia duit

Try this formula in an adjacent cell
Left(yourcell,2)&"/"& right(yourcell,2)&"/"&yearcell
HTH