Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File always opens with Date format set - Excel 2007
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Openig CSV file format with Excel in Office 2007 | Setting up and Configuration of Excel | |||
Excel 2007 unrecognized file format in Excel 2003 More options | Excel Discussion (Misc queries) | |||
Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
Does a format in Excel change when another user opens the file? | Excel Discussion (Misc queries) | |||
Excel 2007 File Problems (Opening New Format) | Excel Discussion (Misc queries) |