date Concatenation
in [Functions]
|
From: tompl on 11 Apr 2010 09:52 Try this: =T6&" " &TEXT(U6,"dd/mm/yyyy")
From: Russell Dawson on 11 Apr 2010 09:54
Please try to give a fuller explanation of what it is you are doing. Data origin/destination. Reasons. Examples. Etc. The more info you can give the easier it will be to assist. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "gb_S49" wrote: > I need to know the date of a movement for a report. The colomns contain over > 2,000 rows. > > "Russell Dawson" wrote: > > > That's because the CONCATENATE formula joins two text strings together. > > The result you are getting is converting the date 10/09/2009 (UK) into text. > > Perhaps you should approach from another angle. > > What are you trying to achieve? Why do you need to join these two cells in > > this way? > > > > -- > > Russell Dawson > > Excel Student > > > > Please hit "Yes" if this post was helpful. > > > > > > "gb_S49" wrote: > > > > > Hi, > > > I am trying to date Concatenate 2 cells. One contains text the other date. > > > How can I get the date to display as a date? > > > =T6&" "&U6 returns ESTIMATE 40066 > > > |