|
MS Excel will allow you to select which date you use as the beginning point for serial numbers. In Personal Computers, this date is January 1, 1900. Excel workbooks imported from the Macintosh environment require you to set the starting date to January 2, 1904--the date used on the Mac. To set these two dates, follow the steps below: - Click on Tools | Options.
- MS Excel will display the Options dialog box.
- Make sure the Calculation tab is selected.
- The 1904 Date System check box controls which dating system is used.
- If the check box is not selected, then the January 1, 1900 starting date is used; if it is selected, then January 2, 1904 is used.
Not difficult at all is it? You can learn lots more at http://www.carolscorneroffice.com.
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
-- Related newsletter articles:
2006/07/13 MS Excel Security Leaks Becoming Flood (excel)
2008/03/26 Cancel a Command in MS Excel (excel)
2005/12/15 Store and Restore Your System with a 'Gut Box' (box)
2008/01/14 Set a language to a Style in Word (box)
2008/01/17 Scale Documents To Size in MS Word Without Reformatting (box)
2006/07/14 More Delays? Vista Release May Be Pushed Back (Again) (date)
2005/04/21 How to Ensure your online Transactions are Secure (box)
2007/09/05 Use Line Numbers When Reviewing Word Documents (box)
2007/02/13 New Excel Attack Threatens Office (excel)
2008/01/22 Microsoft Reveals Excel Security Risk (excel)
2007/07/12 Grid Line Colors in MS Excel (excel)
2006/04/10 Windows System Restore Gone Awol? (date)
2006/01/04 Say the Time v7.0 Review (date)
2006/04/23 Can't Copy and Paste Text as Filename in MS Office? (box)
2007/11/27 Insert an E-Mail Address into a Slide in MS PowerPoint (box)
2007/06/26 Easy Access to Functions in MS Excel (excel)
2007/10/01 Changing Directions In MS Excel (excel)
2008/03/07 Yahoo delays board nominations and Microsoft (date)
2007/02/06 Vista Upgrade DVD Trick: Clean Install Vista Without Previous OS (box)
2008/03/13 More or Less in MS Excel (excel)
-- Recent articles (from all channels): 2008/05/09 Today in History: for Friday, May 09, 2008
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
2008/05/05 Finding Items in MS Outlook's Reading Pane
2008/05/02 [ShellX 20080502]: 'Software Virtualization Solution', and '...
2008/05/02 Rogers Brings iPhone to Canada
2008/05/02 New Google Tool Cuts Down Irrelevant Image Search Results
|
