How to Show Milliseconds in Excel

This post will guide you how to show milliseconds in Microsoft Excel. How do I format cells to time format to include milliseconds in Excel.

Show Milliseconds

Assuming that you have a list of data in range B1:B4, in which contain time values, and if your time values contain milliseconds, when those time values are converted to time format, the milliseconds part will be disappeared. So if there is a way to keep to show milliseconds part in your time values. Just do the following steps:

Step1: select the range of cells that contain time values.

show milliseconds1

Step2: right click on the selected cells, and select Format Cells from the context menu list. and the Format Cells dialog will open.

show milliseconds2

Step3: switch to Number tab in the Format Cells dialog box, and click Custom in the Category list box, and type the format code hh:mm:ss.000 into the Type text box. and click Ok button.

show milliseconds3

Step4: you would see that the milliseconds are shown.


show milliseconds4


So empty here ... leave a comment!

Leave a Reply