Answers

Question and Answer:

  Home  MS Excel

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

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.

 211 views

More Questions for you: