+ Reply to Thread
Results 1 to 3 of 3

Converting a date into text

  1. #1
    Registered User
    Join Date
    05-02-2008
    Location
    UK
    Posts
    6

    Converting a date into text

    I'm trying to use the year of a date field within another cell as a piece of text.

    Each thing I've tried has just returned a numeric value from the date field.

    E.G.

    Cell A1 = 23/12/1971

    I want cell B2 = "1971", which I really want to be able to CONCATENATE into "Year born 1971".

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,486
    Hi Try this

    ="Year Born ,"&TEXT(A1,"yyyy")

  3. #3
    Registered User
    Join Date
    05-02-2008
    Location
    UK
    Posts
    6
    Thanks - thats exactly what I was trying to achieve!

+ 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