| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas and Dates not working in compatibility mode
I have just moved to Excel 2007, and upon opening a frequently used .xls
file, find that no formulas work in it, and all dates have been converted to integer values which do not convert to dates using the DATEVALUE function. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas and Dates not working in compatibility mode
Sounds like you have worksheet set to display formulas not values.
Try CTRL+` ( that on the same key as ~ next to the 1 on top row of keyboard). Let us know if this works best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "AOA" wrote in message ... I have just moved to Excel 2007, and upon opening a frequently used .xls file, find that no formulas work in it, and all dates have been converted to integer values which do not convert to dates using the DATEVALUE function. Any ideas? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulas and Dates not working in compatibility mode
The integer values you see are Excel's way of handling dates. Before
pursuing a formula solution, did you try formatting the integer "date" cells to a date format? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compatibility mode HELP please | Excel Discussion (Misc queries) | |||
| what is compatibility mode and how do you get it off | Excel Discussion (Misc queries) | |||
| Compatibility mode | Excel Discussion (Misc queries) | |||
| compatibility mode | Excel Discussion (Misc queries) | |||
| Compatibility Mode | New Users to Excel | |||
Hybrid Mode
