| 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 |
| 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 | |||
Threaded Mode
