Thread: Decimal Symbol
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dawson Dawson is offline
external usenet poster
 
Posts: 10
Default Decimal Symbol

I am interested in knowing if there is a way in VBa to switch the Decimal
Symbol from the "." to the "," on the fly. For example if the text in B2
was "English" then I would want the Decimal Symbol to be recognized as the
period, but if the text was "French" then the decimal symbol would be the
comma.

Any advice? My goal is to avoid having to switch the regional settings.

Thanks in advance for thinking about it.