Posted to microsoft.public.excel.newusers
|
|
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.
|