Are the cells populated using a macro when the file is opened?

Apparently the values in the cells are being overwritten by new values with
numeric/general format.
Save a copy then in the copy
Copy and PASTE SPECIAL|Values in place and see whether the problem reoccurs.

"Israel" wrote:

I have a problem with Excel 2007, I have some cells with a date value
(11/06/2008), but when I save the file, close it and open it again, in cells
I have this 39758.
I formatted these cell to a date format, any date format, and when I save,
close and open the file, I have 39758 once again. This only happens with a
couple of files.
Can you tell me what is wrong with this?
How can I keep the date format in these cells?

Thank you kindly in advance for your help.

Ed Gonzalez