Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
LOL - Dohhhhhh!!!! Brain freeze time - Thanks for the catch Chip :-)
Regards Ken.................... "Chip Pearson" wrote in message ... Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the current time in a cell? You can? You must have meant CTRL+SHIFT+: "Ken Wright" wrote in message ... Just an aside but do you know you can just use CTRL+SHIFT+ENTER to enter the current time in a cell? -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "GW" wrote in message ... It's currently 10:00 pm. If I input 10:00 in to a cell and hit enter it says 10:00 am. How can I change the default so it is PM. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time entry with am/pm and no colons | Excel Discussion (Misc queries) | |||
Formula for a time card | Excel Worksheet Functions | |||
Setting and KEEPING the default chart | Charts and Charting in Excel | |||
time differences in a column | Excel Worksheet Functions | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |