Concantenate columns with dates and text
 

The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

Concantenate columns with dates and text
 

In Excel, dates are stored as the number of days since the last day of the
nineteenth century (i.e. 1/1/1901 is day 1). Times are recorded as a
fraction of a day. What you see when you type a date into Excel is that
underlying number subjected to a date format.

To work around this, you need to use the Text() function. This will change
your date value to a text date with your chosen format. For example to see
the A1 date in dd/mm/yyyy format together with the content of B1, use the
following:


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

--
Steve

"Dazed and Confused" wrote in
message ...
The first two columns in my spreadsheet are dates. The third is text.
When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

Concantenate columns with dates and text
 

Use the TEXT function to return a date, formatted to display as desired.
For example, if A2 contains your first date, use something like the
following as part of your concatenation...

TEXT(A2,"mmm d, yyyy")

Change the format as desired.

Hope this helps!

http://www.xl-central.com

In article ,
Dazed and Confused wrote:

The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

Concantenate columns with dates and text
 

It sure does! Thanks.

"Domenic" wrote:

Use the TEXT function to return a date, formatted to display as desired.
For example, if A2 contains your first date, use something like the
following as part of your concatenation...

TEXT(A2,"mmm d, yyyy")

Change the format as desired.

Hope this helps!

http://www.xl-central.com

In article ,
Dazed and Confused wrote:

The first two columns in my spreadsheet are dates. The third is text. When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.

Concantenate columns with dates and text
 

Thank you!

"AltaEgo" wrote:

In Excel, dates are stored as the number of days since the last day of the
nineteenth century (i.e. 1/1/1901 is day 1). Times are recorded as a
fraction of a day. What you see when you type a date into Excel is that
underlying number subjected to a date format.

To work around this, you need to use the Text() function. This will change
your date value to a text date with your chosen format. For example to see
the A1 date in dd/mm/yyyy format together with the content of B1, use the
following:


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

--
Steve

"Dazed and Confused" wrote in
message ...
The first two columns in my spreadsheet are dates. The third is text.
When
I try to concantenate, the dates turn into numbers.

Any advice would be greatly appreciated.
Thank you.