Tomatoes originated from the Andes, in what is now called Peru, Bolivia, Chile and Ecuador - where they grew wild. They were first cultivated by the Aztecs and Incas as early as 700 AD.
1. Click any single cell inside a data set. 2. On the Data tab, click Filter. Arrows in the column headers appear. 3. Click the arrow next to Date. 4. Click on Select All to clear all the check boxes, click the + sign next to 2012, and click the check box next to January. 5. Click OK. Result.
For example, suppose cell H11 contained the text Due Date: and cell H12 contained a formula that calculated the date. H12 is correctly formatted for the date data type, m/d/yyyy. If you use the formula =H11&H12 to concatenate these cells, the result comes back with the serial date (such as, Due Date: 39054). Because Excel ignores the formatting of H12, Excel returns the serial date unless the contents of H12 are converted to text before concatenating, as shown in the following formula: =H11&TEXT(H12, mmmm d, yyyy)