Date checking

[Noz2k]

So I have some code which uses the Date, and Now functions.

All works fine on my computer and most others, however on the odd computer it is producing the dates in the American format.

Would this be to do with the system settings of the computer, or the settings in Excel?

And how can you check/change these settings?

 

[anandvarma]

try this

=text(a1,"mm/dd/yyyy")

 

[Noz2k]

Sorry, need to explain myself better. This is generated in VBA. And the date cannot be changed after as the form is automatically sent via email.

I have tried many different ways of formatting the value entered as the correct date, using CDate, and Format but none seem to universally work.

I don't really want to alter the code again, only to find that it doesn't work on another computer in 2 weeks time.

All I want to know is where the function Date, and Now retrieve their information from? Whether it is excel or from the system. And then how to check and amend this so they are consistent across all computers.