Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2014, 04:05 AM
kvitso kvitso is offline Locale-problems? Windows 7 64bit Locale-problems? Office 2010 64bit
Novice
Locale-problems?
 
Join Date: Dec 2014
Posts: 3
kvitso is on a distinguished road
Default 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?
Reply With Quote
  #2  
Old 12-03-2014, 05:49 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Locale-problems? Windows 7 64bit Locale-problems? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 12-03-2014, 07:12 AM
kvitso kvitso is offline Locale-problems? Windows 7 64bit Locale-problems? Office 2010 64bit
Novice
Locale-problems?
 
Join Date: Dec 2014
Posts: 3
kvitso is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 12-03-2014, 10:57 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Locale-problems? Windows 7 64bit Locale-problems? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Locale-problems? 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
Locale-problems? Problems with numbering! Makube Word 5 11-02-2011 07:08 AM
Locale-problems? pst problems - HELP!! hussar Outlook 1 03-07-2011 06:41 PM
Locale-problems? Problems with Bcc beadsworldwide Outlook 3 02-01-2006 03:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft