i want 200505 converted to 200505, the problem is it looks like 200505
but is something else. so when i run a vlookup function to compare
that date with my date i get an inaccurate output b/c excel doesn't
read the 200505 as a date, so when i convert it to a date i get that
strange return i previously posted.


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