Date format

[lo032398]

I am trying to create a chart with a time series using date data whic
looks like (03/24/2004 13:55:00.031)

How do I convert this to an Excel date without a lot of characte
manipulation. When I try to DATEVALUE the data it gives me #VALU

 

[Kevin M]

You can format all the cells that have this in them as
Custom: dd/mm/yyyy this will drop the time displayed in the
cell but it will still be part of the data in the formula bar.
HTH
Kevin M

 

[BrianB]

<without a lot of character manipulation> Sorry, no easy way (grin). Tr
this :-

=DATEVALUE(MID(A1,4,2) &"/" &LEFT(A1,2) &"/" & MID(A1,7,4)
+TIMEVALUE(MID(A1,12,2) &":" &MID(A1,15,2) &":" &MID(A1,18,2)

 

[lo032398]

Worked a treat thanks