Date bug in Numbers

[matracer]

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.

:lol::lol::lol::grumble:

Anybody found any other bugs.

[tilt]

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.

:lol::lol::lol::grumble:

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