Date bug in Numbers
When entering 14/08/06 into cell it is formated to 14 August 0006 (uk date format) instead of 14 August 2006.
When I do the same in excel it correctly works out as 14 August 2006.
I suppose it isn't strictly a bug but could cause confusion if using the DATEDIF function like I did. I couldn't understand why it was showing 730,852 days!!! difference between now and last year.
Anybody found any other bugs.
When I do the same in excel it correctly works out as 14 August 2006.
I suppose it isn't strictly a bug but could cause confusion if using the DATEDIF function like I did. I couldn't understand why it was showing 730,852 days!!! difference between now and last year.
Anybody found any other bugs.
Comments
When entering 14/08/06 into cell it is formated to 14 August 0006 (uk date format) instead of 14 August 2006.
When I do the same in excel it correctly works out as 14 August 2006.
I suppose it isn't strictly a bug but could cause confusion if using the DATEDIF function like I did. I couldn't understand why it was showing 730,852 days!!! difference between now and last year.
Anybody found any other bugs.
I already have a thread here about time arithmetic not working properly. Not a single response to it though.
Cheers