Thread
: [Solved]
Vlookup help for large amounts of stock data
View Single Post
09-21-2012, 07:39 AM
jyfuller
Windows 7 64bit
Office 2007
Advanced Beginner
Join Date: Jun 2012
Posts: 32
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
jyfuller
View Public Profile
Find all posts by jyfuller