Thread: Decimal problem
View Single Post
  #17   Report Post  
Posted to microsoft.public.excel.programming
jaf jaf is offline
external usenet poster
 
Posts: 300
Default Decimal problem

Hi Chip,
Yes, I should have pointed that out also.
Toolsoptionsinternational "system separators"

John


"Chip Pearson" wrote in message ...
"By the way, am I right that VBA always expects "." as decimal sign, regardless of my regional settings?"
Gustaf


No. It's governed by regional settings.


But the regional settings can be overridden in Excel.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Wed, 3 Jun 2009 12:09:39 -0400, "jaf" wrote:

"By the way, am I right that VBA always expects "." as decimal sign, regardless of my regional settings?"
Gustaf


No. It's governed by regional settings.

John