Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenation using dates
I am trying to merge a few cells together, using Concatenation some of which
contain dates, when the cells get merged together it converts the date back to the orginal number that windows stores dates as, is their a way to retain the format as a date in this new merged cell? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Concatenation using dates
Try something like this:
With A1: "The date " B1: 01/29/2007 C1: " is a " Then D1: =A1&TEXT(B1,"MM/DD/YYYY")&C1&TEXT(B1,"DDDD") returns: The date 01/29/2007 is a Monday Does that help? *********** Regards, Ron XL2002, WinXP "Carl Irving" wrote: I am trying to merge a few cells together, using Concatenation some of which contain dates, when the cells get merged together it converts the date back to the orginal number that windows stores dates as, is their a way to retain the format as a date in this new merged cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |