Hi,

I enter dates as dd/mm/yy. Excel then rewrites them as dd/mm/yyyy

In one sheet all the dates have now changed to random numbers. Instead of 16/11/2009 it now reads 40133.

The column isn't formatted (as far as i know) and so far it hasn't done it in the the next column

What is going on?

Thanks
James