Thanks for that, Ben. I've checked the Regional Settings panel and
everything appears to be set correctly for the UK. It even shows today's
date in the correct format as its current example.

As a temp workaround, I've set up a definition in the cell formats list
using the 'custom' entry in the dialogue box to show dd/mm/yy, but there
must be some other way of doing this. Maybe my copy of Office 2000 is one of
those dodgy grey imports from a region that doesn't need non-US settings -
are there such things?

My employer's licence recently enabled a home-user version of the latest
Office edition to be supplied to me direct from MS. As MS required all the
regional details filling in before dispatch, I'm presuming it will operate
without the above issue. I was just trying to avoid the hassle of
uninstalling the old and reinstalling the new.

-Neil


"Ben McBen" wrote in message
...
Suspect this is down to your PCs settings - check control
panel - Regional Options. Are you sure its accepting Euro
dates, and not just those that can be mis-interpreted as
US and leaving others just as text?