Default date in Excel 2000

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
 
D

Dave Peterson

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

windows start button|settings|control panel|regional settings|date tab?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting two cell dates and highlight if over due by a certain amount of days 0
Excel 2007 displayed dates 2
Month Function on UK dates formats (dd/mm/yyy) 2
Default Value =Date$() in UK Date Format 5
Format date 3
Outlook language defaulting to English (US) 1
Default date format (with shortcut keys) 2
Date Problem when marging Excel date into Word 2

Top