| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Convert text to dates
Hello,
I am using Windows XP with Office XP. I have two columns. Column A contains months of the year in the format January, March December etc. Column B contains dates in the format 11th, 16th, 20th etc. Is it possible to combine these two cells to produce a date? Can a sort then be undertaken on this new date column so that all information is sorted chronologically? I tried using concatenate to combine the cells but couldn't get them to be recognised as dates. Thanks in advance for all your assistance. Ket London |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text to numbers | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| convert a column of text to proper | New Users to Excel | |||
| how do I easily convert a single column of text (multiple rows si. | Excel Discussion (Misc queries) | |||
| Convert text file to MS_Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
