I have two colunns,

column A has a real date i.e. 12/31/08
column B has test i.e. Calendar Year

I want column C to read in one line "12/31/08: Calendar Year"

So I entered the following formula in column C:
=A1 & ": " & A2

It works but it looks like this - - - "38717: Calendar Year" ???
I want to then copy/paste special so that I have this actual info to upload
into another program.

How do I format column C so that I get the 12/31/08 to appear in the results?