How to format date cells, Excel template Project scorecard matrix
 

Using Excel 2003 template (Project scorecard matrix) I format the cell as
date 03/14/01. Each time I enter a date it returns a date valve and if I do
not format the cell and enter a date 10/4/06 it automatically formats as
*3/14/01.
How can the cell be saved in the format selected?