Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2011, 10:59 AM
prasad@dmci.ca prasad@dmci.ca is offline Setting default year to 2012 in my spreadsheet Windows 7 32bit Setting default year to 2012 in my spreadsheet Office 2000
Novice
Setting default year to 2012 in my spreadsheet
 
Join Date: Nov 2011
Posts: 2
prasad@dmci.ca is on a distinguished road
Default Setting default year to 2012 in my spreadsheet


I have workbook where I have default all year values to 2012. This when I type in 07 Jan, I would like the 07 Jan 2012 and not 07 Jan 2011. How do I do this so I can set default value to a different year?
Reply With Quote
  #2  
Old 11-30-2011, 05:35 AM
macropod's Avatar
macropod macropod is offline Setting default year to 2012 in my spreadsheet Windows 7 64bit Setting default year to 2012 in my spreadsheet Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,342
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi prasad,

Excel uses the system clock to determine the default year. You have at least four options:
1. Wait till next year,
2. Change the system year to 2012 now,
3. Install a user-defined function to increment the year (this requires vba coding),
4. Enter the required year instead of relying on the default.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting default year to 2012 in my spreadsheet Auto insert year only fithawk Word 11 12-21-2016 02:50 AM
Setting default year to 2012 in my spreadsheet Setting Default TOC Levels in Template Welshie82 Word 1 11-16-2011 03:43 AM
Setting default year to 2012 in my spreadsheet 2012 Calendar angelav6 Office 1 09-07-2011 12:46 AM
Creative Ways for a year-to-year comparison??? ridonkulous5 Excel 1 03-23-2011 04:49 PM
Setting default year to 2012 in my spreadsheet Year janak Excel 6 12-12-2010 10:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:25 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