Cells that are formated as General should take on the internation
settings. I believe in 2007 there may be some bugs and are revverting
to US format. Make sure you have all the office updates.

Using the floowing code will not solve this problem

datevar = format([Date from text box], )

If the cell is general formating it will perform the same algorithm as
if you manually typed the date and do a conversion.

Yo could also have the cells format as "dd/mm/yyyy" which could cause
the problem.

The solution would be to format the cells as "dd/mm/yyyy" or use in a
formula then following

datevar.numberformat = "dd/mm/yyyy"


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=169184

Microsoft Office Help