Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default date format
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Default date format
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cond format with date | Excel Worksheet Functions | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
MS Query Date Format | Excel Discussion (Misc queries) | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions |