how can we convert the date format, suppose I am entering the date as
09/09/2009 using an input box, the macro should take the date as 9/9/2009.

Please help