+ Reply to Thread
Results 1 to 3 of 3

Issue with Function - Getting Nov: 1,2,3,4,5 to display as Nov: 1-5

  1. #1
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Issue with Function - Getting Nov: 1,2,3,4,5 to display as Nov: 1-5

    Hey guys,

    I had some issues creating a formula / macro that took dates ordered: November 1,2,3,4,5 and turning it into November 1-5

    I was provided the code to play around with, however from the attached workbook, it doesnt seem to work in all instances,

    Is anyone able to see where the logic is breaking down?


    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    19,941

    Re: Issue with Function - Getting Nov: 1,2,3,4,5 to display as Nov: 1-5

    UDF.
    See attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-13-2014
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Issue with Function - Getting Nov: 1,2,3,4,5 to display as Nov: 1-5

    Works amazing!

    Thanks for everything

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Display Issue
    By Dbeethekidd in forum Excel General
    Replies: 2
    Last Post: 07-24-2013, 01:26 AM
  2. [SOLVED] Pie Chart Display Issue
    By Steve0492 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2013, 11:06 PM
  3. Replies: 6
    Last Post: 08-13-2012, 05:27 PM
  4. Display issue
    By bluenoser1946 in forum Excel Formulas & Functions
    Replies: 37
    Last Post: 09-06-2005, 07:05 PM
  5. Display Issue...
    By arelian in forum Excel General
    Replies: 0
    Last Post: 03-02-2005, 07:23 AM

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