#1
|
|||
|
|||
Locale-problems?
I have some locale-problems with my Excel-installation (Microsoft Office Professional Plus 2010, v14.0.xxx).
My case is as follows: Cell A1 has the following value: "01.01.2014" (datatype is date) Cell A2 has the following formula: "=TEXT(A1;"dd.mm.yyyy")" Cell A2 displays: "01.01.yyyy" My OS (Win 7 64bit) is set up using Norwegian as language/locale, and if I change the format to "dd.mm.مممم" then it will display the date correctly. However, this workbook is for international usage, and for users in UK the "dd.mm.مممم" format-string will not work. How do I specify that my workbook is to use English (UK) as the locale for everything? What I have tried? 1) File -> Options -> Language ->Editing Languages and Display/Help Languages are all sett to English (UK) / English 2) Ctrl + A in the worksheet to select everything -> Format cells... -> Number -> Date/Time/Special -> Locale = "English (UK)" I have not been able to find any other references to languages. Could someone please help me with this? |
#2
|
||||
|
||||
Have you tried adding the asterisk at the beginning like =TEXT(A1;"*dd.mm.مممم") ? It makes the dates respond to regional settings
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Are you suggesting that "*dd.mm.مممم" will behave like "dd.mm.yyyy" on a computer running an OS with English as system language? In that case, I will try and see if that works
|
#4
|
||||
|
||||
Right click on a cell in Xl, select " Format" and then "dates". You will find the format with asterisk and the explanation when you select it. I think (hope) it should do
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
savedate field, locale settings and style language | eNGiNe | Word | 1 | 05-30-2013 10:57 PM |
scaling problems | bestgepeto | Word | 3 | 02-22-2012 05:31 PM |
Problems with numbering! | Makube | Word | 5 | 11-02-2011 07:08 AM |
pst problems - HELP!! | hussar | Outlook | 1 | 03-07-2011 06:41 PM |
Problems with Bcc | beadsworldwide | Outlook | 3 | 02-01-2006 03:34 PM |