Date format problem when exported from access to excel !!!!!!!!

[Hapr1]

Hello , I have a date format problem , I have an access database which when run by a macro, gives me a date format of 05-AUg-05( data type is text)and the same applies when it 's exported toexcel , it appears as 05-Aug-05. But , when exported to excel i need it in the format 05/08/05.
What should i do for this ?

I think the problem is ,When I run a macro i think the date field is automatically assigned to text , what should i do so tht when it runs a macro it should be in date/time type ?

Thanks for the help in advance .

 

[FoFa]

have you tried converting it using CDATE([TextDateColumn])
you can use a query and base your export on that query to do the conversion.