![]() |
|
|
|
#1
|
||||
|
||||
|
To make things easy extract the dates again using Code:
=MID(F2,1,FIND("---",F2,1)-1))*1
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
#2
|
|||
|
|||
|
Excellent. It works now. Just for my knowledge: Why did it not recognize them as dates with the original formula? How does multiplying by 1 convert the cell into a number that excel recognizes as a date?
Thanks |
|
|
|
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 |