Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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,343
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



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 08:55 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