I'm creating a time sheet for someone and have colums of time on site and time off site. I've tried to format the colums so that if he types 9 then it formats it to a time.
I highlighted the cells and seletect the 'time' format but every time I enter a number it just comes up as 00.00.00
When I remove the format the number I typed in appears.
You might want to either protect the cells the list is in, or make sure it's way way off screen somewhere and set the print area to just the area you do want printed.