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.
Watch this video for an overview of ârestrict cells to a date formatâ. Here are three easy methods to remedy that. Method 1. Use data validation in the cell range to allow only a date to be entered. Choose the Data tab and then select Data Validation/Allow/Date/Between/Enter Starting Date/Enter Finishing Date. While the dialogue box is open add an import message and an error message. Make sure that your error message is set to Stop.