In a helper column add the following
=date(left(a1,4),right(a1,2),1)

This will change all your yyyymm to 1st of that month and year
Now you can do the comparision with this helper column
Or
incorporate this formula within your vlookup to avoid the use of additional
helper column

"badpuppie" wrote
in message ...

I download a report from an online query I have no access to, meaning I
can't manipulate the query. The query returns reports with the date
they were completed in a yyyymm format (or so I thought). I maintain a
log as well and want to compare the two lists. When I run a comparison,
I convert my dates to yyyymm but the vlookup function doesn't work
because the dowloaded report only looks like its in a yyyymm format.
For instance, the dowloaded report looks like: 200312, which is Dec
2003. But when I convert it to date yyyymm it changes to244806 so it
is in some other format that won't allow me to convert it so that I can
compare the two lists in automation. How do I get the dowloaded 200312
to look the same way in a date format?

Thank you.


--
badpuppie
------------------------------------------------------------------------
badpuppie's Profile:
http://www.excelforum.com/member.php...o&userid=15453
View this thread: http://www.excelforum.com/showthread...hreadid=375721