Try this out. Note that I've added a check to see if either the month
or day is less than ten, and if so, lead that figure with a zero.
="="&IF(MONTH(Sheet1!A1)<10,"0"&MONTH(Sheet1!A1), MONTH(Sheet1!A1))&"/"&IF(DAY(Sheet1!A1)<10,"0"&DAY(Sheet1!A1),DAY(Shee t1!A1))&"/"&YEAR(Sheet1!A1)
--
Excel_Geek
------------------------------------------------------------------------
Excel_Geek's Profile:
http://www.excelforum.com/member.php...o&userid=26423
View this thread:
http://www.excelforum.com/showthread...hreadid=398417