De-convert Dates

Giganews Newsgroups
Subject: De-convert Dates
Posted by:  jamasm20…@gmail.com
Date: Thu, 2 Jul 2015

Hi,
I receive a list of passwords on CSV file that may get converted to a date =
format, which renders the passwords unusable. For example, one of the passw=
ords may look like "Jun-02" and the content of the cell is "6/1/7502." Howe=
ver, the actual password is "june7502." My question is, how do I de-convert=
the date format (via VBA), so that the password is in the correct format?
James

Replies