Oct 2 | search
Click here to view Oct 2 news from 60+ newspapers.
Bookmark or Share- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support=vlookup(2,a2:c10,2,true) Using an approximate match, searches for the value 2 in column A, finds the largest value less than or equal to 2 in column A, which is 1.29, and then returns the value from column B in the same row.
- Format a date the way you want - Microsoft SupportWhen you type something like 2/2 in a cell, Excel for the web thinks you’re typing a date and shows it as 2-Feb. But you can change the date to be shorter or longer. To see a short date like 2/2/2013, select the cell, and then click Home > Number Format > Short Date. For a longer date like Saturday, February 02, 2013, pick Long Date instead.
- Excel calendar templates - Microsoft SupportDownload pre-built Excel calendar templates. Stay organized with a variety of Excel calendar layouts and templates you can easily adapt to your needs.
- Create or delete a custom list for sorting and filling dataUse a custom list to sort or fill in a user-defined order. Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list. To understand custom lists, it is helpful to see how they work and how they are stored on a computer.
- Format numbers - Microsoft SupportFix text-formatted numbers by applying a number format. Format numbers as dates, currency, or even fractions to cells in a worksheet. For example, if you’re working on your quarterly budget, the Currency number format shows your numbers as money.
More
