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? |
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? |
All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com