="My Date "&TEXT(A1,"m/d/yyyy")

--
Regards,

Peo Sjoblom

(No private emails please)


"Desert Piranha"
<Desert.Piranha.1zyrxa_1134453003.5104@excelforu m-nospam.com wrote in
message news:Desert.Piranha.1zyrxa_1134453003.5104@excelfo rum-nospam.com...

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