I'm not sure what you mean by "just the numeric", other than perhaps you mean
you'd like to convert the date format 20160606 to a NUMBER.
first, keep in mind that it's ALREADY a number.An Excel "date" is the number of
days since 1/1/1900 DISPLAYED in the requested format (i.e. DDMM)So, to
"c
Hello I'm currently have a workbook with over 2000 lines of information.
What I'm trying to do is to search for a number in the B Column and copy the
results to A2 in sheet2 going down A3 A4 A5 as there is numerious results could
be up to 2000 results for what I searched
The code below searchs
