Excel Formula Bar Time Display Format

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.
 
A

Access Noob

Try custom format:

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

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

Fred Smith

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

Formula Bar - display of content 4
Looking for formula 20
Excel Time Rounding in Excel 2
add time with out weekends 3
Timesheet Calculation with Time Rounded 9
"h:mm" format, but 12-hour time, not 24-hour time? 4
Suming Up Time over the course of days 1
Determine if night shift by start & end time 2

Top