Results 1 to 9 of 9

Grouping dates - Formatting Issue?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-13-2011
    Location
    Havant, Hants, England
    MS-Off Ver
    Excel 2010
    Posts
    116

    Grouping dates - Formatting Issue?

    Hi,

    I'm trying to create a pivot table on the data in the attached file and grouping the expenses into months by right clicking on the data column and selecting "Group". EXCEL gives me an error message "Cannot group that selection". I'm pretty sure it's something to do with the format of the date column (if I take a sample and manually change the dates to standard xx/xx/xxxx format it works fine). I've included the basic download (from a mobile phone) and the pivot table. If anyone can explain to me what the issue is and the solution I would be very grateful,

    regards, Neil
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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