How do I format Excel to show timings.I want to show F1 one lap times to a thousandth of a second

You need to do a custom format.  Go to your number format and then select "More Number Formats" then in the pop-up window you need to select 'Custom' on the left and then type in "mm:ss.000" in the right like shown below: