G
Guest
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!
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!