Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I appreciate any help. This is a problem I posted yesterday probably without
being very clear. How can I override the Windows Regional settings so that my Excel File looks the same in a computer in Italy and in the Netherlands without forcing the user to change the Locale Regional settings? This affects the Date and the Time format, specially within formulas. Also it seems that the locale setting on Cell Format only works if the locale is NOT the default. i.e. A file with the default in UK Eng. and a cell date in Italian and another in UK Eng, will have the cell in Italian on a Dutch computer but the UK one will be turned into Dutch. Besides, this setting does not work within a cell. i.e. the formula TEXT(E12,"*yymmdd")&"-Blabla" will look like 050216-Blabla on a UK Eng, but will look yy0216-Blabla on a Dutch or Italian computer I appreciate any help. This is a problem posted yesterda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
override language settings on date | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
Preserve Excel page settings | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |