Hi All,

Sheet1 has date in A1 (1/1/2005) formated as Date.

Sheet2:
'=IF(Sheet1!A11,"MyDate" & Sheet1!A1) <- formated as Date
and
'="MyDate"&IF(Sheet1!A11,Sheet1!A1) <-formated as Date

Both display - MyDate38353

How can i make it display - MyDate1/1/2005

Any direction?


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=492963