Try custom format:

mm/dd/yyyy h:mm:ss.000

excel 2003 works with that DK what version you're using.

"TanMan" wrote:

How do I get Microsoft Excel to display times on the Formula Bar in 24 hour
time with miliseconds? For example, in a spreadsheet cell I have entered a
custom formatted

Date/Time value of 06/06/2010 22:45:08.555
The Formula Bar shows 6/6/2010 10:45:09 PM

The Formula Bar display has rounded to the nearest second and added the PM
against my better wishes. I have searched Excel Help for information on how
to change this display to no avail. Please help.