Article ID: 192291 - View products that this article applies to.
This article was previously published under Q192291
This article has been archived. It is offered "as is" and will no longer be updated.
For a Microsoft Excel 2000 and later version of this article, see 182247
For a Microsoft Excel 97 and earlier version of this article, see 112361
If Microsoft Excel is set to use the 1900 date system, and you add or subtract data that is formatted with a time format, the date may not be displayed as you expect. When the results of the formula produce a negative value, and this data is formatted to display a time value, the cell displays pound signs, as in the following example:
Although the formula in the cell performs the correct operation, the number format returns the wrong results.
To display the number correctly, use either of the following methods:
Article ID: 192291 - Last Review: October 10, 2013 - Revision: 1.0
Contact us for more help