Text & Date same cell
 

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

Text & Date same cell
 

="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

Text & Date same cell
 

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?

Text & Date same cell
 

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

Text & Date same cell
 

You're welcome.

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