Microsoft Excel Question:
Download Job Interview Questions and Answers PDF
I am using Microsoft Excel 7.0 running under Windows 95. I am using formulas to subtract time. If the resulting time is a negative number, the result displays as pound signs. How can I fix this?
Answer:
This occurs if the 1904 date system option is not checked. This is found under the Tools/Options menu, and on the Calculation tab. It is also in the Workbook Options section.
Download MS Excel Interview Questions And Answers
PDF