Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |