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!

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!

"Gary L Brown" wrote:

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


Thanks Gary, but that's not the answer.

Formatting cells, columns and changing regional setting makes no
difference.... the string needs to be formatted before it reaches the
worksheet. Is it possible to apply a format to the textbox on the userform
so that excel knows how to interpret it?