|
|
#11
09-21-2012, 05:54 AM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 indent alternate lines by different amounts
|
rufusfrog | Word VBA | 5 | 02-25-2012 03:36 AM |
| Charting Help - Stock Prices | Ligerdub | PowerPoint | 0 | 01-03-2012 04:59 AM |
| Stock levels | RobertH | Excel | 5 | 01-24-2011 01:02 PM |
|
chart from large data set
|
mcfie | Excel | 1 | 09-19-2010 03:11 AM |
Windows 7 64bit 
Office 2007
Threaded Mode