Dates US and UK
 

I have some VBA in a workbook that gets date data from SQL Server
2005.

Mystery: when this workbook is opened by some users they get the US
date (ie. 03/01/2008) and some users get the UK date (ie. 01/03/2008)
- the latter is correct (for 1st March 2008).

(1) Which setting on users' pc is causing this divergence?

AND (2) how can I force the date to come as '01/03/2008' regardless of
how the pc/Excel is setup on user pc?

Thanks!