Click on the column header to select the location for your date information. In the Home tab on the Excel ribbon, click on the arrow at the bottom right corner of the Number section.

Select "Cells" from the drop-down menu that appears. The "Format Cells" window pops up. Select "Date" from the "Category" list and then select the type of date formatting you'd like to use.

Jim Desmond To Table-ize a data range, select the relevant cells (including header rows and columns) and click Insert, then Table in the Ribbon menu. Make sure the My Table Has Headers checkbox is ...

For instance, to select the data range A1:C9 (shown below) you could select any cell from A1 to C9. Press [F5]. In the Go To dialog, click the Special button in the bottom-left corner.

In Microsoft Excel, if you select cells containing a date or time and apply the General number format, this generates what appear to be random numbers. In fact, these numbers are anything but ...