Would think all that is needed is select the cell, right click-"Format Cells"
Click on Number tab
Select Date, in Category
From the Type list, select the format desired
OR
Select Custom, in Category
Create a formatting code to your liking
Probably: mm/dd/yyyy
_________________
This message was edited by stevebausch on 2002-10-12 07:02