Leading the way in Microsoft Office Development

Knowledge Base Articles - 2007

182247 - 2007: Negative Date/Time Value Displayed as Pound Signs (###)

211830 - 2007: Time Values Created by Fill Feature May Be Incorrect

Knowledge Base Articles - 2002

291081 - 2002: 12:00:00 AM Is Displayed for Dates Earlier Than 1900

214068 - 2002: Date Values Earlier Than 1900 Appear as Text

214019 - 2002: Method to Determine Whether a Year Is a Leap Year

Knowledge Base Articles - 2000

212114 - 2000: 'am/pm' Changed to 'AM/PM' in Custom Number Format

214315 - 2000: Calculating the Number of Days Between Two Dates

213446 - 2000: Changing an Integer to an Excel Serial Number

214125 - 2000: Converting Hours in Decimal Form to HH:MM:SS Format

214122 - 2000: Converting a Decimal Number to hh:mm:ss Format in Excel

211640 - 2000: Copied and Pasted Dates Are Changed by 100 Years

215971 - 2000: Copy and Paste of Dates Produces Incorrect Dates

213593 - 2000: Date Returned in a Macro Is Four Years Too Early

215193 - 2000: Dates Are Not Incremented Properly When You Fill Large Ranges

214319 - 2000: Dates Truncated When You Save Worksheet as PRN File

205719 - 2000: Early Dates on Office Spreadsheet Component Differ from Excel

223814 - 2000: Error Message: Unable to Read File. 1904 Date System...

214141 - 2000: Formula to Find Number of Weekdays Between Dates

214101 - 2000: Formulas that return the last or first day of a month

237342 - 2000: Four-Digit Years May Display Only Two Digits

213795 - 2000: How to Create a Monthly Calendar

245104 - 2000: How to calculate ages before 1/1/1900 in Excel

214134 - 2000: How to calculate the number of months between two dates in Excel

214094 - 2000: How to use dates and times in Excel

214386 - 2000: Maximum times in Microsoft Excel

248007 - 2000: Number Signs (###) Displayed in Cells of a Worksheet That Contain Dates

215308 - 2000: Two-Digit Year Displayed When You Type a Four-Digit Year

214327 - 2000: Wrong Date Returned When You Enter Month and Digits

215175 - 2000: Wrong Date Saved to Clipboard

Knowledge Base Articles - 1997

113616 - 1997: Converting Dates from yy/mm/dd to mm/dd/yy Format

179584 - 1997: Copied and Pasted Dates Are Changed by 100 Years

190831 - 1997: Error 2015 or Type Mismatch Using Evaluate with Dates

107139 - 1997: Formatting Name of Months in All Capital Letters

236999 - 1997: Four-Digit Years May Display Only Two Digits

067093 - 1997: How to Calculate the Number of Months Between Two Given Dates

095078 - 1997: How to Work With Serial Dates and Julian Dates

168102 - 1997: Lotus 1-2-3 Dates Are Converted to Number

072578 - 1997: MM:SS Format

112361 - 1997: Negative Date/Time Value Displayed as Pound Signs (###)

248394 - 1997: Number Signs (###) Displayed in Cells of a Worksheet That Contain Dates

129073 - 1997: TEXT(MONTH(NOW())'mmm') Always Returns 'Jan'

180162 - 1997: The 1900 Date System vs. the 1904 Date System

075618 - 1997: mm:ss Format in Excel