Formatting a Date Column in an Excel Spreadsheet Created in Report Generator

Purpose: This document will teach the DockMaster user how to format an Excel spreadsheet that was created from a DockMaster export so the data can be sorted by a date column.

Data from DockMaster can be exported to an Excel spreadsheet.  Because all data, including dates, is automatically formatted to text in the new Excel document from the DockMaster export, it may be necessary to change the type data so the sort function will provide accurate results.

Open the new spreadsheet that contains the data to be formatted

1. Highlight the data cell
2. Click on the Data option
3. Click on Text to Columns
4. When the dialog box opens, ensure that Delimited is selected
5. Click Next

                                           

          6. On the next page, uncheck any delimiters

          7. Click Next

                                                            

            8.  When the dialog page opens, select the Date radio button, and set to MDY

            9.  Click Finish

                                                           

The data can now be sorted