LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
n.almeida
 
Posts: n/a
Default override locale computer settings

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
override language settings on date n.almeida Excel Discussion (Misc queries) 0 February 15th 05 02:45 PM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
Preserve Excel page settings ADC Excel Discussion (Misc queries) 5 February 5th 05 08:24 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 05:29 PM
Autocomplete works with my home computer but not the office computer Andy Excel Discussion (Misc queries) 4 December 11th 04 07:21 PM


All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"