Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Auto-detect & format Issues
Is there a way to change the date format that excel automatically defaults to? I do not like the "14-Apr" date format. I notice that when I type in 4/14/07, it defaults to 4/14/2007, which is fine, but when I type 4/14, it always defaults to 14-Apr format. Ideally, it would stay in the format in which it is typed. For example, 6-5 would be displayed as 6-5 (as a date), and 4/14 would be displayed as 4/14 (as a date). Otherwise, I'd prefer excel to default to 04/14/2007 or 2007-04-14 format. Any advice? Thanks for your help, uw805 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Auto-detect & format Issues
It's a PC setting. Close Excel. Start--Settings, Control panel, Regional
settings... Make the short date the format you want. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "uw805" wrote in message ... Is there a way to change the date format that excel automatically defaults to? I do not like the "14-Apr" date format. I notice that when I type in 4/14/07, it defaults to 4/14/2007, which is fine, but when I type 4/14, it always defaults to 14-Apr format. Ideally, it would stay in the format in which it is typed. For example, 6-5 would be displayed as 6-5 (as a date), and 4/14 would be displayed as 4/14 (as a date). Otherwise, I'd prefer excel to default to 04/14/2007 or 2007-04-14 format. Any advice? Thanks for your help, uw805 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Auto-detect & format Issues
Thanks Anne - I did as you suggested, and my "short date" setting is already
in the format I want (4/16/2007). It still defaults to 16-Apr when no year is included. Any other possibilities you can think of? Thanks, uw805 "Anne Troy" wrote: It's a PC setting. Close Excel. Start--Settings, Control panel, Regional settings... Make the short date the format you want. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "uw805" wrote in message ... Is there a way to change the date format that excel automatically defaults to? I do not like the "14-Apr" date format. I notice that when I type in 4/14/07, it defaults to 4/14/2007, which is fine, but when I type 4/14, it always defaults to 14-Apr format. Ideally, it would stay in the format in which it is typed. For example, 6-5 would be displayed as 6-5 (as a date), and 4/14 would be displayed as 4/14 (as a date). Otherwise, I'd prefer excel to default to 04/14/2007 or 2007-04-14 format. Any advice? Thanks for your help, uw805 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto format quarter start date | Excel Discussion (Misc queries) | |||
Date Format Issues Access to Excel | Excel Discussion (Misc queries) | |||
date format/charting issues | Excel Discussion (Misc queries) | |||
auto date: cond. format Question | Excel Discussion (Misc queries) | |||
how do i set up to auto detect duplicated numbers in an excel fiel | Excel Discussion (Misc queries) |