One way:

select the cell(s),
<Data <Text To Columns <Delimited <Finish
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"Paul Ho" wrote in message
...
Hi,
For example. I have a text "5/30/2007 09:30 AM" in cell a1. How can I
convert it to Date format? Thanks.