Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

July 2009 - Nick Hodge's Excel Blog

  • Useless Fact Of The Day

    Excel uses a date system based on it's official start date of 01/01/1900. Days are whole numbers and decimals are time values, so, for example if you type 01/01/1900 12:00 into Excel and then go to Format it as 'General' you will see behind the date and time sits a value, which should be 1.5 (Day 1 and half a day in time). Why all this nauseam? Well, today is 40,000. Having struggled with Excel through the 30,000's today feels like the first day of the rest of my life ;-) Caveat:...
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.