I tried to concatenate cell A1 with date (27.07.2005) and cell B1 with text (INVOICE 777) by using formula in cell C1 (=A1&" "&B1)and received the following result 38560 INVOICE 777. But I want to see the result as 27.07.2005 INVOICE 777. How to avoid the date convertion? Please advise. TIA.