Formatting Dates and Times in Excel

Procedure

  1. To select the column you want to format, click its heading.
  2. Right-click the selected column.
  3. Select Format Cells from the right-click menu.
  4. Click the Number tab, if it is not already selected.
  5. Click the Date category.
  6. Select a timestamp type in the Type group box.
    • If you need to display milliseconds, instead of clicking the Date category, select Custom, and then enter dd-mmm-yyyy hh:mm:ss.000 in the Type field.
  7. Click OK.