#1   Report Post  
LAF
 
Posts: n/a
Default Regional Settings


Is there a way to determine what the regional settings are for a
computer in Excel (i.e. English, German)? Also, is there a way to
determine what the decimal symbol is (. or ,)?


--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=391482

  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

LAF,

This is a Windows question, not an Excel question. Try Start - Control
panel (may vary slightly depending on your version of Windows) - Regional
Settings.
--
Earl Kiosterud
www.smokeylake.com

"LAF" wrote in message
...

Is there a way to determine what the regional settings are for a
computer in Excel (i.e. English, German)? Also, is there a way to
determine what the decimal symbol is (. or ,)?


--
LAF
------------------------------------------------------------------------
LAF's Profile:
http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=391482



  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

MsgBox Application.DecimalSeparator

will work in code -- although, I don't recall if it's always been available.
(It is in xl2002+.)

LAF wrote:

Is there a way to determine what the regional settings are for a
computer in Excel (i.e. English, German)? Also, is there a way to
determine what the decimal symbol is (. or ,)?

--
LAF
------------------------------------------------------------------------
LAF's Profile: http://www.excelforum.com/member.php...fo&userid=9656
View this thread: http://www.excelforum.com/showthread...hreadid=391482


--

Dave Peterson
Reply
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
date format in excel not in line with control panel regional setti GrahamR Excel Discussion (Misc queries) 3 August 2nd 05 06:48 PM
Hyperlink Settings Chris Manning Excel Discussion (Misc queries) 0 June 6th 05 04:21 PM
override locale computer settings n.almeida Excel Discussion (Misc queries) 3 February 18th 05 12:00 AM
Preserve Excel page settings ADC Excel Discussion (Misc queries) 5 February 5th 05 08:24 PM
how to format numbers, digit grouping ,as per regional settings Mayank Excel Discussion (Misc queries) 3 December 31st 04 04:45 AM


All times are GMT +1. The time now is 10:04 PM.

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

About Us

"It's about Microsoft Excel"