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.
|