Format Textual date into excel date!

[Fruitbowl]

Hi!

Quick query for you - I have a form which extracts a date from an email which is pasted into a text box. The date is then moved into a different textbox before being moved onto column A of the worksheet.

The Date comes in THIS format!

"Friday 04th of November 2005 11:28:09PM"

I want it to look like this...

04/11/05

I'm looking for some code that I can add to my cmdAdd command button which is used for adding the data to the worksheet.. the date is held in txtDate (textbox)

Any help would be greatly appreciated!!

Fruitbowl.

 

[Russ At Index]

Hi Fruitbowl,

Try this site ....

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Hope this assists !!!!

Russ.

 

[Fruitbowl]

Many thanks for the assist Russ!

Fruitbowl.