Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The
short date regional setting in windows is 11/22/07. When I go to change the date format the format that is highlighted is Custom dd-mmm. Any idea where this comes from and how I can change it. |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
I think that when you include the year (even if it is only 2 digits) it will use Windows' short date format
-- Kind regards, Niek Otten Microsoft MVP - Excel "Kruppy" wrote in message ... | When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The | short date regional setting in windows is 11/22/07. When I go to change the | date format the format that is highlighted is Custom dd-mmm. Any idea | where this comes from and how I can change it. |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
I usually like mm/dd/yyyy and I've given up fighting excel.
If a cell is going to contain a date, I'll do this: ctrl-; (to enter today's date--and change the format) then type the new date. Kruppy wrote: When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The short date regional setting in windows is 11/22/07. When I go to change the date format the format that is highlighted is Custom dd-mmm. Any idea where this comes from and how I can change it. -- Dave Peterson |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
Nice one, Dave!
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dave Peterson" wrote in message ... |I usually like mm/dd/yyyy and I've given up fighting excel. | | If a cell is going to contain a date, I'll do this: | ctrl-; | (to enter today's date--and change the format) | then type the new date. | | | | Kruppy wrote: | | When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The | short date regional setting in windows is 11/22/07. When I go to change the | date format the format that is highlighted is Custom dd-mmm. Any idea | where this comes from and how I can change it. | | -- | | Dave Peterson |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
Well, lots of times, I enter the date, then hit ctrl-z to undo, then do those
steps. <vbg It can be quicker than formatting the cell. Niek Otten wrote: Nice one, Dave! -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave Peterson" wrote in message ... |I usually like mm/dd/yyyy and I've given up fighting excel. | | If a cell is going to contain a date, I'll do this: | ctrl-; | (to enter today's date--and change the format) | then type the new date. | | | | Kruppy wrote: | | When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The | short date regional setting in windows is 11/22/07. When I go to change the | date format the format that is highlighted is Custom dd-mmm. Any idea | where this comes from and how I can change it. | | -- | | Dave Peterson -- Dave Peterson |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
default date format
Thanks, It is a good work around. There should be a better way to do it but
this is very quick and easy. Thanks againb -- Kruppy "Dave Peterson" wrote: I usually like mm/dd/yyyy and I've given up fighting excel. If a cell is going to contain a date, I'll do this: ctrl-; (to enter today's date--and change the format) then type the new date. Kruppy wrote: When a enter a date in Excel 2003 it formats it (by default) as 22-Nov. The short date regional setting in windows is 11/22/07. When I go to change the date format the format that is highlighted is Custom dd-mmm. Any idea where this comes from and how I can change it. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Date Format | Excel Discussion (Misc queries) | |||
Default date format | Excel Discussion (Misc queries) | |||
Default date format | Excel Discussion (Misc queries) | |||
Default Date Format | Setting up and Configuration of Excel | |||
Excel Default date for date format | Excel Discussion (Misc queries) |