Changing First day of week to Monday (Excel 2007)

  • Thread starter Thread starter ttt980
  • Start date Start date
T

ttt980

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
 
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 ?
 
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
 
Not possible with a register change in 2007
You must also use VBA to do it like in the older versions of Excel
 
Back
Top