![]() |
|
#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 |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
mcfie | Excel | 1 | 09-19-2010 03:11 AM |