Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concatening a text and a date
Hi I'm having trouble concatenating a text string with a date: I cell a1 I have the date 03-may-06 In a different cell I have the function: =CONCATENATE(" This date: ",a1) which returns: This date: 38840. I can't seem to find a function that converts the serial back to the date format that I entered. I could use =CONCATENATE("This date: ", DATE(YEAR(A1),MONTH(A1),DAY(A1))) But that gives me This date: 03/05/2006 Anyone? /Møller -- c991257 ------------------------------------------------------------------------ c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549 View this thread: http://www.excelforum.com/showthread...hreadid=563008 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
turn off convert text to date (i.e. 4-9 to April 9, 2006) | Excel Worksheet Functions | |||
How do I grab the date from a text string? | Excel Worksheet Functions | |||
Converting number or text to a Date Format | New Users to Excel | |||
Macro to convert text to date | Excel Worksheet Functions | |||
EXTRACT TEXT FROM A DATE | Excel Worksheet Functions |