Silly me....

All I had to do after putting in the formula by Bob was to change the
reference A1 and B1 to the ones I wanted and also change the
format.....

Well, its my fault....

Thanks both of you, you have been a great help....


--
mohitmahajan
------------------------------------------------------------------------
mohitmahajan's Profile: http://www.excelforum.com/member.php...fo&userid=8130
View this thread: http://www.excelforum.com/showthread...hreadid=492678