| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatening a text and a date
=CONCATENATE(" This date: ",TEXT(A1,"dd-mmm-yy")) -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=563008 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatening a text and a date
Try with the date in A1,
="This Date: "&TEXT(A1,"dd-mmm-yy") Regards, Alan. "c991257" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concatening a text and a date
Thanks /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 |
| Reply |
| 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 | |||
Linear Mode
