=A1*1

and format as date.

HTH
Jason
Atlanta, GA

-----Original Message-----

I recieve date information in text format...i.e. "01-JAN-
2005", but would
like to convert it to an Excel format date.

I have seen it done before by using a function to split
the text into parts
(getting excel to read the cell as DD-MMM-YYYY) and
output the result using
DAY, MONTH, YEAR function. No idea how to do this though.

Thanks
J
.