I have a spread sheet that was formatted for dates and was working fine. I
turned the keyboard over and now my date column has numbers, ie 38717. If
you highlight the cell you do see the date at the top. I have tried
formatting and text to columns, but I cannot get it to show the date in the
column. This is true for all columns that have date shown or any new columns
I create for dates. When I do try to format there is an * before the date
type and the information at the bottom indicates it will change all to date
values except for items that have an asterisk, but it doesn't tell me how to
get rid of the asterisk. I also tried to change to other types instead of
12/31/05, but that also was unsuccessful. Any comments appreciated.