Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Michael Rekas wrote ...
The situation is that there are ±60 workstations countrywide. A further problem is that there is a routine which extracts data from an SQL database where the date is in text format. We need for everyone in the organisation to set their Short Date to this format. If you have a business need to change the all machines' regional settings, regardless of your Excel project, then do it as a separate project. As regards your Excel project, in your SQL query you should use the CAST function to convert from text to a date on the server i.e. before it arrives into your workbook. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel not using regional settings | Excel Discussion (Misc queries) | |||
Regional settings | Excel Worksheet Functions | |||
Regional Settings with Date | Excel Discussion (Misc queries) | |||
regional settings | Excel Worksheet Functions | |||
Regional Settings | Excel Discussion (Misc queries) |