There is a problem with internation formats. Excel won't convert US (month -
day) to England (day - month) standard or the other way. within one country
you can easily convert using

format(DateValue("1/1/09"),"DD/MM/YYY")

"swiftcode" wrote:

Hi all,

I have a problem with some date formats where people send to me in various
forms (text format)
1) "DD\MM\YYYY"
2) "D\MM\YYYY"
3) "D\M\YYYY"
4) "MM\DD\YYYY"
5) "MM\D\YYYY"
6) "M\D\YYYY"

Is there anyway to be able to convert these to date values and be reflected
as "DD\MM\YYY" using vba.

Thank you for any help rendered in advance.

Rgds
Ray