View Single Post
 
Old 09-21-2012, 07:39 AM
jyfuller jyfuller is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: Jun 2012
Posts: 32
jyfuller is on a distinguished road
Default Ok

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
Reply With Quote