Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #11  
Old 10-31-2020, 10:21 AM
Purfleet Purfleet is offline Date format that displays D/M/Y or just M/Y or just Y Windows 10 Date format that displays D/M/Y or just M/Y or just Y Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

The real benefit of the Alternative & Pivot table is that if anything goes wrong on the pivot table you can delete and start again as the data is on the alternative sheet and in a decent format.

It would be a bit of a chore to change from the across view you start with to the alternative view. Not impossible but manual work.

The outline is easy to add, just select the column you want to be able to hide then click on Data > Group (on the right under Outline)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge field mistakenly interpret text format as date format alan6690 Mail Merge 0 09-02-2020 01:54 AM
Create Field That Displays Date+30, Office 2007 Papote Word 6 10-09-2016 02:47 PM
Date format that displays D/M/Y or just M/Y or just Y Date format but with Jan Feb mar etc how is this done ? DBenz Excel 3 12-21-2014 05:00 AM
Letter date changes when merging with Excel - not the format, the actual date! Smallweed Mail Merge 1 02-07-2014 06:00 PM
date format gsrikanth Excel 1 12-28-2011 05:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:29 PM.


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