Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The date default when you put in 2/19 is 19-Feb. I find this incredibly
annoying because I never want the date in that format. I would prefer that it appear as 2/19/10 (or whatever the current year is). I have found that if I put in 2/19/10, it comes out in that format, but I don't always type the date in in that format. Is there any way to change the default setting in Excel to this format across all my spreadsheets? Or do I have to change the date format each time I type in a date? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default date format | Setting up and Configuration of Excel | |||
How do I set the default date | New Users to Excel | |||
Default date format | Excel Discussion (Misc queries) | |||
Default Date Format | Excel Discussion (Misc queries) | |||
Excel Default date for date format | Excel Discussion (Misc queries) |