Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-28-2023, 03:06 AM
p45cal's Avatar
p45cal p45cal is offline "Cannot Group That Selection" issue with dates in Excel Pivot Table Windows 10 "Cannot Group That Selection" issue with dates in Excel Pivot Table Office 2021
Expert
 
Join Date: Apr 2014
Posts: 962
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default

It's less how they're formatted more the actual contents; in some rows you have text, not real Excel dates. Below, those left justified are strings, those right justified are good:
2023-06-28_110357.jpg
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
"Cannot Group That Selection" issue with dates in Excel Pivot Table Irritating formatting issue in Table of Contents - page number "dots" disappear Eriks Word 9 04-19-2019 06:18 PM
"Cannot Group That Selection" issue with dates in Excel Pivot Table Pivot table dates issue salse Excel 1 06-08-2016 12:23 PM
Excel Macro to "Select All" in Pivot Table Field galkej Excel 0 02-03-2014 11:59 AM
Excel pivot table into an MS Word Doc "office 2007" wmarsh3561 Excel 1 01-09-2010 08:03 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:02 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft