+ Reply to Thread
Results 1 to 2 of 2

Slicer for table with date column showing wrong result

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    Oslo
    MS-Off Ver
    2016
    Posts
    21

    Slicer for table with date column showing wrong result

    In the attached file I have a table with two columns a and b. Column a has dates formatted as months, that is "mmm" (Jan, Jan, Jan, Jan, Feb, Feb, Feb, Feb), and column b formates the dates in column a with the TEXT function as =TEXT( [@a], "mmm" ). The columns look the same, but the slicers for the columns behave different. The slicer for column a shows only one line when sorted for Jan or Feb. And the slicer for column b shows all the lines and are correct. Why is that?

    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert José Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Slicer for table with date column showing wrong result

    Hi
    I suppose the reason is related to the properties of the cell
    In Excel, a cell has values and text that may be different as is the case.
    VBA
    Range("A2"). Value ------> 01/01/2016
    Range("A2"). Value2 ----> 42370
    Range("A2"). Text -------> jan (is the text que are displayed in cell A2
    Range("B2"). Value -----> jan
    Range("B2"). Value2 ----> jan
    Range("B2"). Text -------> jan

+ 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. value not showing in the result column
    By Jdnethaji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2015, 05:22 PM
  2. Pulling the start and end date from a pivot table slicer
    By rwiper11 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-27-2015, 08:51 AM
  3. Change Pivot Table Column field on Slicer selection (Excel 2013)
    By kevboyo in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-27-2014, 11:36 PM
  4. [SOLVED] Help. Column showing same result no matter what the referenced cell's value.
    By swiftrain in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-01-2014, 08:57 AM
  5. Combo box cell link showing wrong date
    By kojo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-29-2011, 05:51 AM
  6. VBA Save w/ date showing Wrong Date
    By CBG05QB in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-13-2011, 12:23 PM
  7. Pivot table showing wrong data (date not month)
    By rushdenx1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-17-2010, 06:59 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