View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Richard O. Neville Richard O. Neville is offline
external usenet poster
 
Posts: 23
Default Default date format

Control Panel - Regional and Language Options allows you to set the time
format your prefer as a default. You may have to restart the computer to
make it effective.

"Amy" wrote in message
...
When using the NOW function sometimes it returns the date with the time in
military and others not in military. How can I always have it return not
in
military?