I have Excel 2007 but have to save files in 97 Format (.xls). I have a
spread sheet that I have formatted the cells for accounting, number and
percentages formats. Everything looks great until I save the file, than when
I re-open it all the formatting changes I made are gone, but if I save the
file in .xlsx format everything works fine. Unfortunately, several of the
users who need access to my file are still using 97 Excel; so, I have to find
a way to save this file with the proper format.