I have a date i need to concantenate with a text cell which contains one word. The date cell contains the date as 20150604 which appears in the formula bar as 6/4/2015. It is a custom format. the other cell contains a simple text. I am using the concantenate furmula which comes up with the following result: 42157word. How can i get it to return back the exact same date format which appears in the cell which in this case is 20150604word.
Any help on this would be really appreciated.
Bookmarks