My Excel 2007 file opens with all the sheets' formatting set to Date. I will
reset the sheet format to General, set the cell formats to either date or
currency as desired, and then save the file. When I reopen it, all the cells
that I did not specifically set will be reverted to the Date format again.
I would like the file to open with the General format as default, but it
appears to open with the Date format as default. I have checked the options
but cannot find something that will do this.
Note that I converted this file from an Excel 2002 format.
This does not happen with other Excel files.