Formulas and Dates not working in compatibility mode

A

AOA

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?
 
B

Bernard Liengme

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
 
D

Dave O

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas & Dates not working in .xls file 1
Moon phases and julian dates 0
Date value won't work in formulas. 1
Help differentiating numbers and dates 3
Dates and Formulas 2
Ye Olde Date Formate Probleme - PLEASE HELP 3
Excel 2003 sheet containing look ups won't open in Excel 2007 3
Backwards Compatibility with Excel 2002 2

Top