Excel String Concatenation Question

For example, I have

40572 in A1. However, it is set to "Date", so what I see is actually 1/29/2011

888 in B1. Nothing fancy.

=A1&B1 in another cell. It shows 40572888.

However, what I want to see is 1/29/2011888 while still having 40572888 in the values. So that the first 5 digits are viewed as "Date" and the rest as "General". I don't want to use开发者_开发问答 "=TEXT" because it doesn't preserve the value 40572. Is this possible?

Did you try via CONCATENATE

Example:

A1 = 1/29/2011
B1 = 888 
C1 = CONCATENATE(TEXT(A1, "MM/DD/YYYY"), " ", B1)

Please try on your own, because my excel is only available in german ;)

Btw: what do you mean with

it doesn't preserve the value 40572