Select the cell and give it a custom format of mmddyy. Select Format Cells
on the Number tab, select Custom in the Type box, enter mmddyy OK.

Hope this helps,

Hutch

"rebecca" wrote:

How can I change the date format 01/01/08 to 010108