Please I need help in formating date. I have the following types of dates.

What I have I want to achieve this.
August 2006 08/01/2006
July 2008 07/01/2008
May 2nd 2003 05/02/2003

All help totally appreciated.

Thanks

FinalDate = Format(Your_Date, "mm/dd/yyyy")
--
Robert
Author of RibbonX: Customizing the Office 2007 Ribbon:
LATEST INTERACTIVE TUTORIAL:
http://www.msofficegurus.com/videos/...p_HT_Chart.asp
FORUM: http://www.msofficegurus.com/forum/

If they are real date, just use a cell format of mm/dd/yyyy.

If it is a string as shown, use =TEXT("01 " &A1,"mm/dd/yyyy")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Yossy" wrote in message
...
Please I need help in formating date. I have the following types of dates.

What I have I want to achieve this.
August 2006 08/01/2006
July 2008 07/01/2008
May 2nd 2003 05/02/2003

All help totally appreciated.

Thanks

Thanks guys, Bob your formula works but not for dates like September 2nd 2006.
Also I do not understand what Robert Martim means. Please clarify

Thanks a big bunch.

"Bob Phillips" wrote:

If they are real date, just use a cell format of mm/dd/yyyy.

If it is a string as shown, use =TEXT("01 " &A1,"mm/dd/yyyy")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Yossy" wrote in message
...
Please I need help in formating date. I have the following types of dates.

What I have I want to achieve this.
August 2006 08/01/2006
July 2008 07/01/2008
May 2nd 2003 05/02/2003

All help totally appreciated.

Thanks