convert text to dates
 

Want to convert text date "30 AUG 2006" to a date. Have used "=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.

convert text to dates
 

Use TTC (Text to Columns).

Select the column, then:
<Data <Text To Columns
And click "Delimited", then <Next <Next

Click on "Date", and make sure that "DMY" shows in the window,
Then <Finish,
And you've got XL recognized dates.

You can now format the data any way you wish.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Ben" wrote in message
...
Want to convert text date "30 AUG 2006" to a date. Have used
"=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.

convert text to dates
 

Hi,
If you have the text date "30 AUG 2006" in cell A1. you can use
=datevalue(a1) or =datevalue("30 AUG 2006"). if the answer return in number
like 38959 you can format it. (if you use =datevalue("a1") it will answer
#value!.)
yui

"Ben" เขียน:

Want to convert text date "30 AUG 2006" to a date. Have used "=DATEVALUE()"
but comes back with #value!.
Would greatly appreciate help here.