+ Reply to Thread
Results 1 to 4 of 4

How to convert/combine date to text?

  1. 03-31-2013, 11:50 AM #1
    mnur
    mnur is offline
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    How to convert/combine date to text?

    Hi Forum,
    I want to combine a text with a date.

    Thank in advance..
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-31-2013, 11:58 AM #2
    Spencer101
    Spencer101 is offline
    Valued Forum Contributor
    Join Date
    04-03-2012
    Location
    East Sussex, UK
    MS-Off Ver
    Excel 2003:2010
    Posts
    893

    Re: How to convert/combine date to text?

    In C2 - =B2&", "&TEXT(A2,"DD/MM/YYYY")
    In C3 - =B3&", "&TEXT(A3,"DD MMMM YYYY")
    If I've been of help, please hit the star
    Reply With QuoteRegister To Reply
  3. 03-31-2013, 12:07 PM #3
    mnur
    mnur is offline
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: How to convert/combine date to text?

    i got like this
    =B2&", "&TEXT(A2;"dd/mm/yy")
    =B2&", "&TEXT(A2;"dd mmmm yyyy")

    any other?
    Reply With QuoteRegister To Reply
  4. 03-31-2013, 12:09 PM #4
    mnur
    mnur is offline
    Registered User
    Join Date
    03-25-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: How to convert/combine date to text?

    Thank you @Spenser!
    I missed the third row...
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1