try activecell=format(mydate,"dd/mm/yyyy")

--

Gary
Excel 2003


"JohnnyP" wrote in message
...
when using input box mydate and i try to put the date into the active cell
it
changes from dd/mm/yyyy to mm/dd/yyyy how can stop this. Code follows

mydate = InputBox("Enter date as dd/mm/yyyy or Cancel to edit", Date,
Date)
activecell=mydate