Tag: OfficeApps

The following is a list of data store and configuration files used by Microsoft Outlook. Some of the folders might be hidden folders. To view them, do one of the following: Windows XP Click Start, and then click My Computer. On the Tools menu, click Folder Options, click the View tab, and then click the Show hidden files and folder option. Windows 2000 Double-click My Computer on your desktop. On the Tools menu, click Folder Options, click the View tab, and then click the Show hidden files and folder option. Your configuration may not include all of the following files. […]

Data Validations: Checking whether the cell has a number or not, usually useful while checking accounts/transactions/banking sheets. =(F2-(IF(ISNUMBER(D3),D3,0))) + (IF(ISNUMBER(E3),E3,0)) Checking whether the cell is BLANK, usually useful in textual/string validations =(F2-(IF(ISBLANK(D3),D3,0))) + (IF(ISBLANK(E3),E3,0)) Conversions: Date values: India to US Input Date Format: 7/1/2011  (days in single digits) Conversion Formula: DATE(YEAR(B3),DAY(B3),MONTH(B3)) Output Date Format: 1/7/2011 Input Date Format: 14/01/2011  (days in two digits) Conversion Formula: DATEVALUE(MID(B8,4,2)&”/”&LEFT(B8,2)&”/”&RIGHT(B8,3)) Output Date Format: 1/14/2011 Reference articles: How to use dates and times in Excel HOW TO: Convert Dates in Imported Files from yy/mm/dd to mm/dd/yy Format in Excel 2000