Function GetDate(v)
GetDate=right(v,5) & "/20" & mid(v,2,2)
end function

--
Tim Williams
Palo Alto, CA


"Sandspirit" wrote in message ps.com...
Hi,

I have a file that is imported from Attachmate Extra!. The dates appear
in Excel as i.e. 106/04/14, which represents April 14, 2006. How can I
convert all these dates to the standard 04/14/2006 format using VBA? I
have NEVER seen a date format like the one from Attachmate. Please
help.

Thanks!

Sandspirit