Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2012, 11:51 AM
ketanco ketanco is offline How to change number format of dates Windows 7 64bit How to change number format of dates Office 2007
Expert
How to change number format of dates
 
Join Date: Dec 2011
Posts: 269
ketanco is on a distinguished road
Default How to change number format of dates


Hello,
I would like to change the number format of dates. Right now they show just month and day. I want it to show year too. How can I do it?

How about if I wanted only the summary task at the very top show it that way(month, day, year) and everything else below it remain the same?
Reply With Quote
  #2  
Old 09-11-2012, 02:34 PM
JulieS JulieS is offline How to change number format of dates Windows 7 64bit How to change number format of dates Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

The date display is controlled through Tools > Options, View tab. Short of custom fields to show dates formatted differently in different fields, you cannot accomplish your second request.

You can have different views with difference date formats by changing the table definition. Choose View > Tables, More tables, select the table and edit to see the Table Definition dialog.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Footnotes: custome number format btorrance Word 2 07-30-2012 10:47 AM
Custom Number Format for Chart deadrxn24 Word 4 03-18-2012 05:38 PM
How to change number format of dates custom number format: change thousands separator Ward Excel 1 06-07-2011 08:18 PM
Numbering, defining new number format nrschmid Word 0 12-30-2009 03:04 PM
How to change number format of dates Default Number Format boutells Excel 1 05-20-2009 02:46 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:00 PM.


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