date & time

N

nannybears

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Menu Macro Not Executing - Need Help 1
separating date and time 5
Creating Forms 0
Keyboard shortcut for current date and time 1
Time/Date auto insert upon click 0
Convert string to military time string 14
Assigning function to Ctrl+Space and it worls wrongly 2
Calculate end date and time 1

Top