Quote:
Originally Posted by Debaser
Excel stores dates as the number of days since 31/12/1899.
In your example, 100 +50+50 = 200. 200 days from 31/12/1899 is 18 July 1900. Therefore the simple answer is that your formula cell was formatted as a date. All you needed to do was change the number format as mentioned and you would have seen the correct result.  |
Thank Debaser, I didn't know that, also I don't know how
I managed to put a date formula into a previously empty
cell, or why the formula that I put in didn't overwrite it.
Thank anyway.
Mike.