Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the date 09/01/07 come up as January 9, 2007?
When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why
is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the date 09/01/07 come up as January 9, 2007?
Hi Confused,
Try your Windows regional settings, sounds like they are set to something other than US. StartSettingsControl PanelRegional and Language Options HTH Martin "Confused" wrote in message ... When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the date 09/01/07 come up as January 9, 2007?
One thing to check is the cell format (Format/Cells). Another thing to check
is Windows short date regional setting (Control Panel/Regional and Language Options). "Confused" wrote: When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the date 09/01/07 come up as January 9, 2007?
Dates default to the Country/Region set in the Windows operating system. You
set this via Control Panel and this is the format for entering all dates in Excel. In Excel you can set the date format for particular cell/s via the Number format. However, when you do this, if your operating system date is set to day month year and you format dates within excel to be month day year then when you enter a date in the formula bar you must still enter it inthe country/region format of day month year and allow Excel to alter the format within the spreadsheet. Regards, OssieMac Y "Confused" wrote: When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the date 09/01/07 come up as January 9, 2007?
Thanks JMB, MartinW & OssieMac. The regional settings was exactly what I was
looking for. I live in Canada so, of course, I set the settings to Canada. Apparently we Canadians use the day-month-year format. I set it to U.S. and it went back to month-day-year. "Confused" wrote: When I type September 1, 2007 as 09/01/07 excel formats it to 09-Jan-07. Why is that? It didn't used to do this, it changed to this recently and I can't find the option to change it back. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
Format date in excel 2000 like '31st January 2005' | Excel Discussion (Misc queries) | |||
using date function, month shows as January when i type (12) | Excel Discussion (Misc queries) |