Peo & Rowan,
Thx much, Both work fine.
Thx Again
Dave
Rowan Drummond Wrote:
Try:

=IF(Sheet1!A11,"MyDate"&TEXT(Sheet1!A1,"dd/mm/yyyy"),"")

Hope this helps
Rowan

Desert Piranha wrote:
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