I work with a lot of datasets from outside sources with times in the format mm:ss.000.
As such I'm constantly copying them into new workbooks, where excel will display the relevant columns as mm:ss.0. Changing them is simple enough and quick enough, but my life would be fractionally better if I could make it DEFAULT (in any new workbook) to three decimal places.
This is about TIMES, not DATES, and because I'm talking about fractions of a seconds it's not possible to do via the locale/region settings in Windows' Control Panel. At least, I don't think it is? Possible?
Update:
This question is different from this similar one, as in regional settings it's not possible to choose a time format with decimals of a second.
