Excel Formula Bar Time Display Format

  • Thread starter Thread starter TanMan
  • Start date Start date
T

TanMan

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.
 
Try custom format:

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

excel 2003 works with that DK what version you're using.
 
The format of the formula bar is controlled by your Windows Regional
Settings. Go to Control Panel and change them there. There's no way that I
know of to get the milliseconds displayed, though.

Regards,
Fred
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping Time in Pivots. 2
Formula bar in Excel 2010 2
advice on rounding or ceilng a 24 hour time value 3
Looking for formula 20
Round Date & Time 1
Formula Bar - display of content 4
add time with out weekends 3
Need help calculating time 8

Back
Top