Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding What Cultural Environment An XLS Was Created In: Excel 200
Hello All,
Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment. Any help would be greatly appreciated. Thanks, Alcide |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding What Cultural Environment An XLS Was Created In: Excel 200
Define "Cultural Environment"??? Version, language, ???
-- HTH... Jim Thomlinson "Alcide" wrote: Hello All, Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment. Any help would be greatly appreciated. Thanks, Alcide |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding What Cultural Environment An XLS Was Created In: Excel
Hello Jim,
Thanks for the reply. Pardon the vagueness of my question, which reflects our unfamiliarity with this matter. I assume it is language that we want. Our problem is that Euro-style dates are being changed to American-style. One of our users wants to know what language(maybe?) the workbook was saved in so they would have forewarning of any formatting issues BEFORE they open the file. I hope this helps. Thanks again for your response. Alcide "Jim Thomlinson" wrote: Define "Cultural Environment"??? Version, language, ??? -- HTH... Jim Thomlinson "Alcide" wrote: Hello All, Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment. Any help would be greatly appreciated. Thanks, Alcide |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding What Cultural Environment An XLS Was Created In: Excel
things like the date, and currency format are functions of Windows Regional
Settings, not excel, so there is no way to tell what the formatting on the other computer was from the file. "Alcide" wrote: Hello Jim, Thanks for the reply. Pardon the vagueness of my question, which reflects our unfamiliarity with this matter. I assume it is language that we want. Our problem is that Euro-style dates are being changed to American-style. One of our users wants to know what language(maybe?) the workbook was saved in so they would have forewarning of any formatting issues BEFORE they open the file. I hope this helps. Thanks again for your response. Alcide "Jim Thomlinson" wrote: Define "Cultural Environment"??? Version, language, ??? -- HTH... Jim Thomlinson "Alcide" wrote: Hello All, Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment. Any help would be greatly appreciated. Thanks, Alcide |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding What Cultural Environment An XLS Was Created In: Excel
Jim is correct, but a possible solution would be to use formats that don't look
at the regional settings. If you go to FormatDate, the list tells you which are based on regional settings, and which are not. -- Regards, Fred "dlw" wrote in message ... things like the date, and currency format are functions of Windows Regional Settings, not excel, so there is no way to tell what the formatting on the other computer was from the file. "Alcide" wrote: Hello Jim, Thanks for the reply. Pardon the vagueness of my question, which reflects our unfamiliarity with this matter. I assume it is language that we want. Our problem is that Euro-style dates are being changed to American-style. One of our users wants to know what language(maybe?) the workbook was saved in so they would have forewarning of any formatting issues BEFORE they open the file. I hope this helps. Thanks again for your response. Alcide "Jim Thomlinson" wrote: Define "Cultural Environment"??? Version, language, ??? -- HTH... Jim Thomlinson "Alcide" wrote: Hello All, Does anyone know of a way to determine what cultural environment an Excel workbook was created in before opening the workbook? We tried right-clicking and looking in properties, but didn't see any property referencing the environment. Any help would be greatly appreciated. Thanks, Alcide |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
open separate Excel windows in dual monitor environment | Setting up and Configuration of Excel | |||
Can excel regognise asp environment? | Excel Discussion (Misc queries) | |||
what is ERP environment | New Users to Excel | |||
Is it possible to use excel in a multi user environment? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |