Results 1 to 3 of 3

Thread: represent date in text

  1. #1

    Question represent date in text



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I am trying to represent date in
    Jan-11
    Feb-11
    and so on...(I am manually typing this dates)

    only limitation is Actually it should be same not 1/1/11...
    means on formula bar it should not display 1/1/11 or 1-Jan-11

    As I am going to compare it with another cell(where this cell text is genrated using "=TEXT(I4,"mmm")").
    And most imp I dnt want to put another cell to convert it in text like did it above.

    Is it possible?
    I dnt know weather i explained my requirement properly or not...!

    Thanks in advance

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    767
    Articles
    0
    Excel Version
    2010
    Hello Ashurk77
    When you type the dates, try preceding them with an apostrophy (i.e. 'Jan-11). This forces Excel to store your data as text, instead of converting it to a date format. If my example is typed into A1, then the formula =TEXT(A1, "mmm") will return Jan.

    HTH
    Hercules

  3. #3
    Conjurer royUK's Avatar
    Join Date
    Mar 2011
    Location
    Derbyshire, UK
    Posts
    155
    Articles
    0
    Excel Version
    most versions
    How are you comparing the entries. A formula to compare them could be

    =IF(TEXT((A1),"mmm")=D1,1,0)

    Real date in A1, text date in D1
    Hope that helps

    Roy

Posting Permissions

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