Monday, November 24, 2008

How to turn off new message notification in Outlook 2003

How to turn off new message notification in Outlook 2003

Tools -> Options -> [Preferences Tab] E-mail Options -> Advanced E-mail Options -> Uncheck 'Play a sound' and 'Display a New Mail Desktop Alert' ... OK, OK, OK.

How to use a formula to format a date as month name in Excel 2003

=TEXT(MONTH(A3),"mmmm")


How to use a formula to format a date as month name in Excel 2003

More Custom Number Format in Excel 2003

Part II.

How to use the AND function in Excel

AND() works like this
=and(logical1,[logical2], …)