Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Bar Time Display Format
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Bar Time Display Format
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formula Bar Time Display Format
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 "TanMan" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display time in 12 hour format | Excel Worksheet Functions | |||
Display time format | Excel Discussion (Misc queries) | |||
How do I display time in a negative format? | Excel Worksheet Functions | |||
display no seconds in time format [h] | Excel Discussion (Misc queries) | |||
entering numbers to display a time format | Excel Discussion (Misc queries) |