| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| Toggle a range of Julian dates to Gregorian Dates and Back | Excel Programming | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Hybrid Mode
