Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Concatenation
Hello all,
I'm trying to concatenate two cells with dates. The concatenation works; however, the dates change formats. Formula: =concatenate(i34," and ",j34) Result: 38596 and 39325 What I want: 01-SEP-05 and 31-AUG-07 I'm assuming I need to wrap the concatenating cells in some type of date format. Modifying the destination cell; e.g., changing it to a date format, does not work. Thoughts? alex |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Concatenation
try
=Text(i34,"dd-mmm-yy")&" and "&text(j34,"dd-mmm-yy") "alex" wrote: Hello all, I'm trying to concatenate two cells with dates. The concatenation works; however, the dates change formats. Formula: =concatenate(i34," and ",j34) Result: 38596 and 39325 What I want: 01-SEP-05 and 31-AUG-07 I'm assuming I need to wrap the concatenating cells in some type of date format. Modifying the destination cell; e.g., changing it to a date format, does not work. Thoughts? alex |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Concatenation
=TEXT(I34,"dd-mmm-yy") & " and " & TEXT(J34,"dd-mmm-yy")
-- Gary''s Student - gsnu200740 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Concatenation
On Aug 28, 8:42 am, Duke Carey
wrote: try =Text(i34,"dd-mmm-yy")&" and "&text(j34,"dd-mmm-yy") "alex" wrote: Hello all, I'm trying to concatenate two cells with dates. The concatenation works; however, the dates change formats. Formula: =concatenate(i34," and ",j34) Result: 38596 and 39325 What I want: 01-SEP-05 and 31-AUG-07 I'm assuming I need to wrap the concatenating cells in some type of date format. Modifying the destination cell; e.g., changing it to a date format, does not work. Thoughts? alex- Hide quoted text - - Show quoted text - Thank you both for your help; it worked! alex |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Worksheet Functions | |||
Concatenation | Excel Discussion (Misc queries) | |||
concatenation | Excel Discussion (Misc queries) | |||
Concatenation using IF AND - Possible? | Excel Worksheet Functions |