| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if data in one cell, then date in adjacent cell | Excel Worksheet Functions | |||
| extract name when a date in another cell gets near | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
Linear Mode
