Thread: [Solved] "Cannot Group That Selection" issue with dates in Excel Pivot Table
View Single Post
 
Old 06-28-2023, 03:06 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 956
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