Default date in Excel 2000

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Hello,

I am trying to work with dates in Excel 2000 and I have a
problem I cannot seem to resolve. When I enter a date in
a UK form it appears to be expecting a US form as
anything with a day greater than 12 enters as text and
all date formnatting is ignored. I've checked my
language settings and these are UK English and they show
the date as UK format, I am using Windows Xp Pro. Can
anyone suggest a solution for me?

Thanks,

Jon
 
When you checked your date formats, did you check the windows regional settings:

windows start button|settings|control panel|regional settings|date tab?
 
Hi Dave,

thanks for this, yes it was one of the first things I
checked I have United Kingdom settings and the dates are
showing in the Regional and Language options as the
correct UK dates. From my experience I believe this
should then have carried across to my Excel 2000 but it
does not seem to.

Can you suggest anything else to look at?

Thanks,

Jon
 
I don't have another guess.

This could be a waste of your time. Try changing that short date format to
something else. Then change it back. (I've seen weirder things work.)

Sorry,
 
Back
Top