| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date & time
Working in a spreadsheet to track contact information, I need to date/time
stamp each entry and created a macro for a shortcut key to accomplish this. (Ctrl + ; space Ctrl + Shift + ;) It works great...except the time changes to military time for the PM. How/where do I change this? Thank you for any help you can offer. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date & time
Format cells
-- David Biddulph nannybears wrote: Working in a spreadsheet to track contact information, I need to date/time stamp each entry and created a macro for a shortcut key to accomplish this. (Ctrl + ; space Ctrl + Shift + ;) It works great...except the time changes to military time for the PM. How/where do I change this? Thank you for any help you can offer. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Linear Mode
