Date format from numbers to a real date?
 

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?

Date format from numbers to a real date?
 

Brw wrote:
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?


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

Date format from numbers to a real date?
 

Remember that Excel maintains dates as date serial numbers. January 1, 1900
is day 1, January 2, 1900 is day 2, December 25, 2008 is day 39,807,
December 31, 9999 is day 2,958,465. When you see the number 39,807 formatted
as "dddd, mmmm dd, yyyy", you get Thursday, December 25, 2008. What you
refer to as a "real date" is actually just a number formatted to look like a
date.

Tyro

"Brw" wrote in message
...
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?