Microsoft Excel Question:
Download Questions 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

Previous QuestionNext Question
How do I clear all formatting and cell contents from the cell in my spreadsheet?I am working in MS Excel 5.0 in Windows 95. I have a spreadsheet where the gridlines are not printing. The sheet is 87 rows by 49 columns, "A1 to AW87." The gridlines are not printing from column "AP" to "AW." The other gridlines are printing correctly. What is the problem?