Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get actual date from variable text string
The one that you presented that isn't recognized as a date is 113006; Excel
will convert the others automatically. You can convert unpunctuated strings using the text to columns wizard. Select the cell (or contiguous vertical range of cells) with the unrecognized date format, go to Data menu Text To Columns. Click Next twice, and in step 3 select the date format option in the top right, then in the dropdown choose a string for the existing date format (e.g., MDY). Option two is to visit the users with a large blunt object. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Richard" wrote in message ... I'm importing dates that are from a text field filled in by numerous people, so it could be in a host of formats. e.g. 30-Nov-06 or 113006 or 11/30/2006 or November 30th, 2006. How can I convert to true Excel Date format? (I realize there may be no macro that gets it right all the time.) -- Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text strings from a variable string | New Users to Excel | |||
Extract a number from a variable text string | Excel Discussion (Misc queries) | |||
find a variable text string | Excel Discussion (Misc queries) | |||
Getting text file into a VBA string variable | Excel Programming | |||
& reference answering as Date Serial # not actual text | Excel Worksheet Functions |