Convert date + time text format to date format

[Guest]

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.

 

[RagDyeR]

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!
=====================================================



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.

 

[Dave Peterson]

If your windows short date is in mdy order, you may want to try just selecting
that column and

Edit|Replace
what: / (slash)
with: /
replace all