+ Reply to Thread
Results 1 to 3 of 3

Formula needed to get Date in text based on numbers

  1. 01-25-2014, 08:13 PM #1
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Formula needed to get Date in text based on numbers

    Hi,

    I have following numbers in Column A. I need formulas to get results shown in Column B and C.

    ColumnA ColumnB ColumnC
    Numbers Formula?? Formula??

    200001 January Jan 00
    200101 January Jan 01
    200102 February Feb 01
    200710 October Oct 07
    200912 December Dec 09

    Thank you
    Last edited by caabdul; 01-25-2014 at 08:40 PM.
    Reply With QuoteRegister To Reply
  2. 01-25-2014, 08:27 PM #2
    berlan
    berlan is offline
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Formula needed to get Date in text based on numbers

    One option, see attached
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 01-25-2014, 08:40 PM #3
    caabdul
    caabdul is offline
    Forum Contributor
    Join Date
    12-25-2011
    Location
    Lahore, Punjab, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    287

    Re: Formula needed to get Date in text based on numbers

    Thank you berlan
    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)

Similar Threads

  1. [SOLVED] HELP needed with an average formula that takes into account numbers and text
    By halgraham in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 05-11-2013, 06:26 PM
  2. [SOLVED] Formula assistance needed to sum data based on anniversary date and month date
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-28-2012, 11:18 PM
  3. Help needed for Formula that counts based on Date & 3 criteria
    By sellim in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2012, 02:30 PM
  4. [SOLVED] Formula needed based on cumulative numbers
    By ramblin in forum Excel General
    Replies: 3
    Last Post: 06-22-2012, 05:53 AM
  5. Formula needed to convert text to numbers
    By Bulldogs2011 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2011, 05:22 PM

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