Make sure you are saving the file as an .xlsx (or some 2007 variant) file.
If you are using the enchanced formatting in 2007 and save the file as .xls,
you will loose that formatting.

If that does not solve it, post back with the kind of formatting problems
you are having. Cell fills, currency, conditional, etc.
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"2007headache" wrote:

When working with Excel2007, why do I lose my cell format after I close a
file then reopen it? For example: I format a column as a date, save the
changes and close the file, but when I reopen the file the column converts
back to General and I lose the date format (this is just one of the number of
pains Im dealing with, but I thought I would start with this complex
question first). This is causing hours of wasted time and effort. I cant
be the only one with this problem.
--
I bet Bill Gates uses an Apple!