This problem is simple to correct but is very very annoying
what I'm doing is to type a hour range, eg. (0-1),(1-2),(2-3) so on per cell row
DATE --- HOUR
Excel stupidly keeps formatting
1-2 to a date
to make matters worse is when I change it to a number format
I also cannot find the AutoFormat option in excel 2010, I am aware of the Format button in home but there is no autoformat there.