Date Formatting Bug

[Guest]

Hi

The problem is regarding populating a cell with a date, from a textbox in a user form. I find that when populating dates (from a user form into a cell in Excel), the date format reverts to the American style e.g. mm/dd/yy. This occurs even when I specify date format as dd/mm/yy in the code AND on the spreadsheet. I have done a number of tests and found the problem to arises when the dd is 01, 02, 03.... up to 12. Therefore if the dd is up to 12, it reverts to the American format as it thinks it's a month. If the dd is 13 and over, it recognises that it can't be American and formats correctly to dd/mm/yy

Being in Australia DD/MM/YY is the preferred date format

Any suggestions why this may be happening and what could be done to fix it would be greatly appreciated.

 

[Nigel]

Try this link to reveal how Excel deals with dates, the userform issue is a
known feature(!) -

http://www.cpearson.com/excel/datetime.htm

Cheers
Nigel

Hi,

The problem is regarding populating a cell with a date, from a textbox in

a user form. I find that when populating dates (from a user form into a cell
in Excel), the date format reverts to the American style e.g. mm/dd/yy. This
occurs even when I specify date format as dd/mm/yy in the code AND on the
spreadsheet. I have done a number of tests and found the problem to arises
when the dd is 01, 02, 03.... up to 12. Therefore if the dd is up to 12, it
reverts to the American format as it thinks it's a month. If the dd is 13
and over, it recognises that it can't be American and formats correctly to
dd/mm/yy.

Being in Australia DD/MM/YY is the preferred date format.

Any suggestions why this may be happening and what could be done to fix it

would be greatly appreciated.

 

[Guest]

Do you have any references that specifically discuss the UserForm issue?

Thanks

Timshel

 

[Nigel]

I assume that you have looked at the mircosoft library on this topic but if
not here is a reference for you.....

http://msdn.microsoft.com/library/d...y/en-us/dnovba00/html/InternationalIssues.asp

Cheers
Nigel

 

[Guest]

Nigel

Once again very useful..

Thanks for all your hel

Cheers

Timshel