+ Reply to Thread
Results 1 to 7 of 7

Sorting "" properly for date formatted column

Hybrid View

  1. #1
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Sorting "" properly for date formatted column

    I see what is happening. I left a few blank rows and filled the formula down....the result was that the filter reverted to A-Z type sorting. If I entered a date after the blank area, the filter again reverted back to Oldest to Newest again. It is an oddity that the blank cells if not "bracketed by dates" (date entered after the blanks) will be treated as text.

    I would convert all the data to a table and not fill any more rows than you have data for. All formulae will fill as you add more rows.
    Last edited by newdoverman; 05-06-2015 at 06:09 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. [SOLVED] Date Format "d-mmm-yy" as Worksheet Name does not sort properly
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-13-2013, 03:35 PM
  2. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  3. Format(date,"mm/dd") returns date formatted as "mm-dd"
    By MenacingBanjo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2013, 09:15 AM
  4. In Excel a cell formatted "currency" shows "######" help!
    By llveda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2006, 04:40 PM
  5. [SOLVED] Excel shouldn't ***** about a "date format" when formatted as txt
    By Ibbits in forum Excel General
    Replies: 5
    Last Post: 07-18-2005, 01:05 PM

Tags for this Thread

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