Concantenate columns with dates and text

  • Thread starter Thread starter Dazed and Confused
  • Start date Start date
D

Dazed and Confused

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.
 
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
 
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
 
It sure does! Thanks.

Domenic said:
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
Click to expand...
 
Thank you!

AltaEgo said:
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
Click to expand...
 
Back
Top