| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
