Re: Merging Cells when one cell is a date

Tech-Archive recommends: Speed Up your PC by fixing your registry

=A2&", "&TEXT(B2,"mm/dd/yy")

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I am trying to merge two cells using the formula:
=A2&", "&B2. B2 is a date
>and when it merges it switches the date to a series of
numbers. I have tried
>changing the cell formating but I don't seem to be able
to get it to merge
>the date without loosing it's formating.
>
>Any help would be appreciated.
>.
>
.

Relevant Pages

  • Re: Using DDE as source in mail merge
    ... So an autocorrect will cause the 20% to multiply ... or a single cell has a weird format set. ... If your worksheet is formatted using numbers and the cells formatted as ... longer to add the switches - and you only have to do it once. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: misconceptions on computer science
    ... >>consider a system having, say, internal clock. ... > Actually I was thinking of cells. ... > mathematically can be represented with switches. ... > consciousness cannot be represented physically. ...
    (comp.object)
  • RE: 3-D formulas... can it work for text too?
    ... Atlanta, GA ... "Xanadude" wrote: ... > I'm trying to incorporate it into the =countif function, ... The cells are in the same position on all pages to be ...
    (microsoft.public.excel.misc)
  • Re: Help with a formula
    ... > HTH ... > Atlanta, GA ... >>cells within that area? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Counting Letters
    ... What is the whole formel if the cells to work in is B11-B73? ... > HTH ... > Atlanta, GA ...
    (microsoft.public.excel.worksheet.functions)