Dates US and UK

R

ronn2007

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing UK date to US format 1
Problems with date formats 6
Open txt file without changing date 1
US - British Dates 1
Comparing two dates using between. 1
Date Difference in Complete Tax Years 1
VBA time and date? 1
Date issue in Access 2003 query 1

Top