date shown in number in form

[iqss]

hi all

this is my first post.
i have an attendance sheet which has a name column and a row which have dates(1-dec-09 to 30-dec-09)i have to put present ,absent or leave for all the workers in the sheet which is little difficult so i want to use form,but in the form the dates are shown in numbers (41010...)
how to display the dates in ddmmyy or any other format in the form .
thanks.

iqbal.

[Palmetto]

Select all of cells that will contain dates
Press Ctrl + 1 keys or right -click and choose Format Cells

In the Format Cells dialog, choose the Number tab, click on Date in the cateogry section and pick the desired date format.