Sometimes you have to chenge the format in a single cell since the whole
column deal does not work. it happened to me few times and I am not sure why

"Amy" wrote:

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?