Excel requires a custom date/time format be entered in order to display a full date and time down to the seconds. Excel does not have a standard format that includes the full date and time down to the second, only down to the minute.
Excel provides the ability to display the full date and time using the custom format feature. The format to display the full date and time can be entered manually for a column, and the Format Paste feature used to apply the format to each of the date/time columns.
To format a date/time column to display the full date and time down to the seconds:
To apply the format to the remaining columns:
- Open the CSV file in Excel
- Click the column header of the first date/time column
- Right click the column header and select "Format Cells..."
- Select the "Number" tab
- Select "Custom" from the category list
- In the "Type" field enter "m/d/yyyy hh:mm:ss AM/PM"
- Click "OK"
Repeat this process for each additional column that requires the full date/time displayed down to the seconds.
- Select the column showing the date/time format just entered
- Click the format painter icon (the paint brush icon)
- Click on the column header for the next date/time column that needs the full date/time formatting
Did this Frequently Asked Question provide the information you were looking for? Provide us with your
Feedback and suggestions for improving this FAQ.