RE: Concatenation using dates

Try something like this:

With
A1: "The date "
B1: 01/29/2007
C1: " is a "

Then
D1: =A1&TEXT(B1,"MM/DD/YYYY")&C1&TEXT(B1,"DDDD")

returns: The date 01/29/2007 is a Monday

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Carl Irving" wrote:

I am trying to merge a few cells together, using Concatenation some of which
contain dates, when the cells get merged together it converts the date back
to the orginal number that windows stores dates as, is their a way to retain
the format as a date in this new merged cell?
.

Relevant Pages

  • RE: Wrap text is tempermental within a single cell
    ... multiple paragraphs in the merged cell. ... lines with Alt+Enter prior to pasting, "Paste Special', trying both formats ... confirming the text in word is all the same format prior ...
    (microsoft.public.excel.misc)
  • Date formatiing - using code to show months
    ... the row giving a sequential row of dates. ... I would like to automatically format the row below the dates to show merged ... The day date row of course updates each day so i would like the month row to ... merged cell with just "September" below the vertically formatted row of days ...
    (microsoft.public.excel.misc)
  • Data Validation Macro
    ... I trying to create a code the will validate my data in a range of ... B5:D5 is a merged cell ... I want to insure that the user enters data in this format ... I think I would have to use some type of worksheet change event ...
    (microsoft.public.excel.programming)
  • Re: Function for duplicating Merged cells
    ... FYI...Using Excel 2000 ... >I've tried changing the format from general to text and ... >>if M7 is the address of the merged cell. ... >>Frankfurt, Germany ...
    (microsoft.public.excel.worksheet.functions)