+ Reply to Thread
Results 1 to 4 of 4

Unification of Date-formatted cells

  1. #1
    Registered User
    Join Date
    12-24-2004
    Location
    Sofia, Bulgaria
    MS-Off Ver
    MS Office 2010
    Posts
    31

    Question Unification of Date-formatted cells

    Hi guys, here is my question:

    I have in A1 number "123" and in B1 "16.07.2008", formatted as Date.
    In order to unite those cells with slash between them, I write the following formula:

    =A1&"/"&B1

    The problem is, that I do not get 123/16.07.2008, but 123/39645

    How to get the real date with this unification?

    Please, help!

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898
    Try:

    =A1&"/"&Text(B1,"dd.mm.yyyy")
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Unification of Date-formatted cells

    Try this:

    Please Login or Register  to view this content.
    or...as an exercise in how the TEXT function works
    Please Login or Register  to view this content.
    Does that help?
    Last edited by Ron Coderre; 07-16-2008 at 09:08 AM.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  4. #4
    Registered User
    Join Date
    12-24-2004
    Location
    Sofia, Bulgaria
    MS-Off Ver
    MS Office 2010
    Posts
    31
    Quote Originally Posted by NBVC
    Try:

    =A1&"/"&Text(B1,"dd.mm.yyyy")

    It works!

    Thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1