Hi everyone,

Recently a co-worker came to me with a work sheet that she had been using to
track dates that invoices were received. She told me the sheet was working
fine one day. The next day, when she entered a date, the cell would only
return the serial date no matter how she formatted the cell. The actual date
would appear correct in the formula bar, but the cell showed only the serial
date. We have tried everything I can think of to get the cells to format to
show the date but have not had any success. I finally solved her delima by
copying all the data to another new worksheet and using the paste special -
values only command. I was just wondering if anyone has ever heard of such
an incident and what might have caused it. Thanks.

Ron