Q. I keep getting endless pound signs (#) in my cells. What am I doing wrong?
A. This usually occurs when Excel thinks you’re trying to calculate something that results in negative days or negative time. It can be more a format problem than a calculation problem. If you are expecting a value representing the difference between two times or dates in a numeric value, all you have to do is clear the formats (Home, Editing, Clear, Clear Formats). If you want the result to be formatted as a time or a date, then you will need to reverse your calculation. In other words, it will need to result in a positive number.