+ Reply to Thread
Results 1 to 3 of 3

Changing Date into Text Help

  1. #1
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    134

    Changing Date into Text Help

    Can you change a date into text?

    For example,
    A1 is 02/18/10....and I want A2 to say "Feb" or even "1" would be helpful.

    Thanks,

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Changing Date into Text Help

    If you have a date in A1 you can custom format the cell as "mmm" to show Feb or "mmmm" to show February.

    If you want the result in another cell you can use TEXT function, e.g.

    =TEXT(A1,"mmm")

    If you want the month number use MONTH function, i.e.

    =MONTH(A1)

    [or with formatting format date cell as just m]
    Audere est facere

  3. #3
    Registered User
    Join Date
    07-07-2010
    Location
    Roanoke, VA
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Changing Date into Text Help

    If in A1 it says 2/18/11 and in b2 you put in the formula =month(a1) it would return a 2, which is the month of the date in the reference cell.

    Hope that helps

+ 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