I am currently trying to make a standard template for a
journal request form for my job.

I am using input boxes to ask certain questions and
obviously return the answers in the specified cells
however one question is "Enter the posting date" (make
note I am in the UK so our date format is dd/mm/yy) when I
enter a date 01/10/04 the computer automatically switches
it to 10/01/04 and I have checked the cell formatting and
all is correct.

Can you think of anyway to stop/correct this?

Thanks for your help!

ans = InputBox("enter Date")
cells(1,1) = cdate(ans)

--
Regards,
Tom Ogilvy


"James Newton" wrote in message
...
I am currently trying to make a standard template for a
journal request form for my job.

I am using input boxes to ask certain questions and
obviously return the answers in the specified cells
however one question is "Enter the posting date" (make
note I am in the UK so our date format is dd/mm/yy) when I
enter a date 01/10/04 the computer automatically switches
it to 10/01/04 and I have checked the cell formatting and
all is correct.

Can you think of anyway to stop/correct this?

Thanks for your help!