I have a site with 1000+ nodes that all contain a simple day of the week select field where the values are set out like this:
Sunday|Sunday
Monday|Monday
Tuesday|Tuesday
Wednesday|Wednesday
Thursday|Thursday
Friday|Friday
Saturday|Saturday

I would like to set up a view using this field as a sort criteria but clearly it isn't going to work like this and perhaps I should have set it up as something like:
1|Sunday
2|Monday
3|Tuesday
4|Wednesday
5|Thursday
6|Friday
7|Saturday

Can anyone tell me how I can change the values of this field or if there is another way of achieving this.

Thanks for your help,

nobody click here