Date format from numbers to a real date?

  • Thread starter Thread starter Brw
  • Start date Start date
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?
 
Brw said:
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?
Click to expand...


=TEXT(A1,"mm/dd/yy")&": "&B1
 
Back
Top