software

Hi I know this is a problem for lots of people but I still cant find an
answer. I have imported a text file into excel with a number field that
displays credit card expiry dates as a 4 digit number. example 0408 so month
year. I have converted the number field to a text field so it doesnt drop
off the first zero and now I need to convert it to a date field. Any nice
easy simple ideas. Any help would be much appreaciated. Or direction to a
question the same.

Perhaps

=DATE(100 RIGHT(A1,2),LEFT(A1,2),1)

format as date--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514596Using a helper column.....

=LEFT(A1,2)amp;quot;/quot;amp;RIGHT(A1,2)amp;quot;/quot;amp;2006

or you can leave off the year, as....

=LEFT(A4,2)amp;quot;/quot;amp;RIGHT(A4,2)Vaya con Dios,
Chuck, CABGx3quot;julietquot; gt; wrote in message
...
gt; Hi I know this is a problem for lots of people but I still cant find an
gt; answer. I have imported a text file into excel with a number field that
gt; displays credit card expiry dates as a 4 digit number. example 0408 so
month
gt; year. I have converted the number field to a text field so it doesnt
drop
gt; off the first zero and now I need to convert it to a date field. Any nice
gt; easy simple ideas. Any help would be much appreaciated. Or direction to a
gt; question the same.
gt;
gt;
juliet wrote:
gt; Hi I know this is a problem for lots of people but I still cant find an
gt; answer. I have imported a text file into excel with a number field that
gt; displays credit card expiry dates as a 4 digit number. example 0408 so month
gt; year. I have converted the number field to a text field so it doesnt drop
gt; off the first zero and now I need to convert it to a date field. Any nice
gt; easy simple ideas. Any help would be much appreaciated. Or direction to a
gt; question the same.
gt;
gt;
While it looks like you have a solution I would point out that an
Excel spreadsheet is a very insecure place to store credit card
numbers. Especially if you are storing them WITH the expiration date.
Numbers should only be stored encrypted and then only if absolutely
necessary.

Here's just one link demonstrating the issues. Also you may want to
check with the card companies themselves (Visa, Mastercard, Amex)as
to what they require to comply with their requirements to store the
numbers.

All in all storing credit card info should not be taken lightly. If
a security breech occurs it can have serious implications.

gls858

gls858 wrote:
gt; juliet wrote:
gt;gt; Hi I know this is a problem for lots of people but I still cant find
gt;gt; an answer. I have imported a text file into excel with a number field
gt;gt; that displays credit card expiry dates as a 4 digit number. example
gt;gt; 0408 so month year. I have converted the number field to a text
gt;gt; field so it doesnt drop off the first zero and now I need to convert
gt;gt; it to a date field. Any nice easy simple ideas. Any help would be much
gt;gt; appreaciated. Or direction to a question the same.
gt;gt;
gt; While it looks like you have a solution I would point out that an
gt; Excel spreadsheet is a very insecure place to store credit card
gt; numbers. Especially if you are storing them WITH the expiration date.
gt; Numbers should only be stored encrypted and then only if absolutely
gt; necessary.
gt;
gt; Here's just one link demonstrating the issues. Also you may want to
gt; check with the card companies themselves (Visa, Mastercard, Amex)as
gt; to what they require to comply with their requirements to store the
gt; numbers.
gt;
gt; All in all storing credit card info should not be taken lightly. If
gt; a security breech occurs it can have serious implications.
gt;
gt; gls858

forgot the link sorry.
www.ingrian.com/resources/sol...ecurity-sb.pdf