| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format/concatenation
I have a concatenation in cell C1 based on cells A1 and B1 as follows:
A B C 405 1/31/06 Concatentate(A1,&"-",&B1) Cell C1 subsequently reads 405-38748. I have been changing formats in cell B1 with no luck. I need cell C1 to read 405-1/31/06. What am I missing? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
format/concatenation
Try this:
=A1&TEXT(B1,"-m/d/yy") HTH, Elkar "alm09" wrote: I have a concatenation in cell C1 based on cells A1 and B1 as follows: A B C 405 1/31/06 Concatentate(A1,&"-",&B1) Cell C1 subsequently reads 405-38748. I have been changing formats in cell B1 with no luck. I need cell C1 to read 405-1/31/06. What am I missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
