Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing First day of week to Monday (Excel 2007)
How to tell excel that my first day of week is Monday (instead of Sunday)?
I have changed "HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek from "6" to "0", but no result. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing First day of week to Monday (Excel 2007)
Hi
In the 2007 beta I already ask for a way to change this in the UI. I never try to do this in the register Do you want to use the Excel 2007 week filter or something else ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... How to tell excel that my first day of week is Monday (instead of Sunday)? I have changed "HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek from "6" to "0", but no result. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing First day of week to Monday (Excel 2007)
Thanks for reply.
yes, i'm having this problem using excel 2007 built-in week filters. I have not found (in Regional Settings UI) how to change the the first day of week, so I have tried to modify the registry. I'm using EXCEL 2007 SP1 Thanks "Ron de Bruin" wrote: Hi In the 2007 beta I already ask for a way to change this in the UI. I never try to do this in the register Do you want to use the Excel 2007 week filter or something else ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... How to tell excel that my first day of week is Monday (instead of Sunday)? I have changed "HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek from "6" to "0", but no result. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing First day of week to Monday (Excel 2007)
I will try to play with it this weekend
For 97-2003 I have this option build-in in this add-in http://www.rondebruin.nl/easyfilter.htm Time to make a 2007 version -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... Thanks for reply. yes, i'm having this problem using excel 2007 built-in week filters. I have not found (in Regional Settings UI) how to change the the first day of week, so I have tried to modify the registry. I'm using EXCEL 2007 SP1 Thanks "Ron de Bruin" wrote: Hi In the 2007 beta I already ask for a way to change this in the UI. I never try to do this in the register Do you want to use the Excel 2007 week filter or something else ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... How to tell excel that my first day of week is Monday (instead of Sunday)? I have changed "HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek from "6" to "0", but no result. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing First day of week to Monday (Excel 2007)
Not possible with a register change in 2007
You must also use VBA to do it like in the older versions of Excel -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... I will try to play with it this weekend For 97-2003 I have this option build-in in this add-in http://www.rondebruin.nl/easyfilter.htm Time to make a 2007 version -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... Thanks for reply. yes, i'm having this problem using excel 2007 built-in week filters. I have not found (in Regional Settings UI) how to change the the first day of week, so I have tried to modify the registry. I'm using EXCEL 2007 SP1 Thanks "Ron de Bruin" wrote: Hi In the 2007 beta I already ask for a way to change this in the UI. I never try to do this in the register Do you want to use the Excel 2007 week filter or something else ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "ttt980" wrote in message ... How to tell excel that my first day of week is Monday (instead of Sunday)? I have changed "HKEY_CURRENT_USER\Control Panel\International\iFirstDayOfWeek from "6" to "0", but no result. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007) | Excel Worksheet Functions | |||
Simple? Formula for "for the week starting Monday May Xxth" | Excel Worksheet Functions | |||
date of monday of each week automatically | Excel Discussion (Misc queries) | |||
How can I get the monday of a given week number? | Excel Discussion (Misc queries) | |||
Microsoft Excel : How can we get the date of the Monday of Week 44 of Year 2005? | Excel Worksheet Functions |