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. |
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. |
All times are GMT +1. The time now is 04:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com