Thanks. It works now
I cannot sort these dates. I separated them with text in the form date---stock symbol (11/12/2012---jonny321) using mid(MID(F2,1,FIND("---",F2,1)-1)) to only have the date in the cell. For some reason excel is not interpreting the cell as a date anymore. Is there a way for me to convert the current cells back into date form so they can be sorted?
|