Thread: date & time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nannybears nannybears is offline
external usenet poster
 
Posts: 7
Default 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.