| 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. |
| 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) | |||
Threaded Mode
