Check your settings in the 'Regional Options' of your Windows 'Control
Panel'. Check that the settings are appropriate for your region which, I'm
guessing, is not the US.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Black1" wrote:

Hi,

I asked this question a long time ago and can no longer find the answer (or
the file that I used it in) so I'd appreciate a reminder....

I've built an excel tool for our department that asks the user to enter the
data via a series of forms, the problem I'm having is with the dates. Excel
seems to be fairly abitrary about whether it is going to interpret a date as
US or UK format... when it's obvious (30/06/05 for example) it will use the
UK format and take it as 30th June, yet if the next entry is 01/07/05 it uses
the US format and takes it as 7th January.

Entry is through a textbox, I just can't figure out how to format it before
it misinterprets it.

Excel 97 on xp

Thanks!