Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default Regional Options

Hello,
Has does VBA handle regional options. For example, if I have a variable in
the code that is defined as follows:

Var1 = 0.003 - Var2

Does it matter for those in Europe (where the decimal separator is ",")?

Thanks,

Bill


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,316
Default Regional Options

Windows handels regional settings and Excel follows the Windows settings. To
change regional settings click the START button and select CONTROL PANEL. In
the CONTROL PANEL double-click on REGIONAL SETTINGS and set whatever needs
setting.
--
Kevin Backmann


"Bill" wrote:

Hello,
Has does VBA handle regional options. For example, if I have a variable in
the code that is defined as follows:

Var1 = 0.003 - Var2

Does it matter for those in Europe (where the decimal separator is ",")?

Thanks,

Bill



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
Dates using Regional Options AussieDave[_2_] Excel Programming 2 September 5th 06 03:17 PM
Using VBA to temporarily bypass regional options Carim[_3_] Excel Programming 5 March 9th 06 02:34 PM
Regional options support for currency [email protected] Excel Programming 0 August 8th 05 09:57 PM
Regional options support question Splinter[_2_] Excel Programming 0 August 1st 05 09:04 PM
Regional Options and Decimal symbol from VBA Henrik Wikström Excel Programming 1 August 2nd 03 04:01 AM


All times are GMT +1. The time now is 12:26 AM.

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"