Hi,

This is perplexing me - I've got a sheet that when I set a cell to a
display format of..say Date, and enter 30/12/2003 (UK format), it displays
ok in the formula bar, as the date, but in the cell it becomes 37985. I
thought it could be set to Number format, as opposed to Date, but it
definitely is set to Date.

Opening a new workbook works fine, but obviously I can't do that, as I've
done all the work in this one...

Anyone got any ideas as to why this is occuring?

Thanks,

Ben
--
BWGames
to email change de.news to de-news