B
Brw
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?
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?