Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates formatted as text | Excel Discussion (Misc queries) | |||
imported text data converting to dates | Excel Discussion (Misc queries) | |||
Convert text to numbers | Excel Worksheet Functions | |||
convert value stored as text to logical refrence value! | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |