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.

It is defined in the regional settings of windows. It shouldn't need any
intervention if the workbook is being used no two different computers with
different regional settings.

--
Regards,
Tom Ogilvy


"dawson" wrote:

> 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.

Thanks for your reply Tom.

Most of the users who work with the spreadsheet work on English and French
files with different copies of the workbook. They have their regional
settings at English, but when they need to work on a French file they need to
switch the Regional settings to get the currency format correct. I was
looking for a way to provide them with a macro so they could switch the
Decimal Symbol from within excel (without having to adjust the regional
settings) on a file by file basis.

Anything else I could try?

Thanks again.

"Tom Ogilvy" wrote:

> It is defined in the regional settings of windows. It shouldn't need any
> intervention if the workbook is being used no two different computers with
> different regional settings.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "dawson" wrote:
>
> > 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.

read through these threads:

http://groups.google.com/group/micro...02b371eb13edfb

http://groups.google.com/group/micro...0f630c42dec3c1

http://groups.google.com/group/micro...ming&rnum=22#9

--
Regards,
Tom Ogilvy


"dawson" wrote:

> Thanks for your reply Tom.
>
> Most of the users who work with the spreadsheet work on English and French
> files with different copies of the workbook. They have their regional
> settings at English, but when they need to work on a French file they need to
> switch the Regional settings to get the currency format correct. I was
> looking for a way to provide them with a macro so they could switch the
> Decimal Symbol from within excel (without having to adjust the regional
> settings) on a file by file basis.
>
> Anything else I could try?
>
> Thanks again.
>
> "Tom Ogilvy" wrote:
>
> > It is defined in the regional settings of windows. It shouldn't need any
> > intervention if the workbook is being used no two different computers with
> > different regional settings.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "dawson" wrote:
> >
> > > 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.

Bad copy on that last one:

http://groups.google.com/group/micro...d093/9855b0cd1

c4db097?lnk=st&q=change+regional+setting+group%3Amicrosoft.public.excel.programming&rnum=22#9855b0cd1c4db097

"dawson" wrote:

> Thanks for your reply Tom.
>
> Most of the users who work with the spreadsheet work on English and French
> files with different copies of the workbook. They have their regional
> settings at English, but when they need to work on a French file they need to
> switch the Regional settings to get the currency format correct. I was
> looking for a way to provide them with a macro so they could switch the
> Decimal Symbol from within excel (without having to adjust the regional
> settings) on a file by file basis.
>
> Anything else I could try?
>
> Thanks again.
>
> "Tom Ogilvy" wrote:
>
> > It is defined in the regional settings of windows. It shouldn't need any
> > intervention if the workbook is being used no two different computers with
> > different regional settings.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "dawson" wrote:
> >
> > > 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.

> Most of the users who work with the spreadsheet work on English and French
> files with different copies of the workbook. They have their regional
> settings at English, but when they need to work on a French file they need
> to
> switch the Regional settings to get the currency format correct. I was
> looking for a way to provide them with a macro so they could switch the
> Decimal Symbol from within excel (without having to adjust the regional
> settings) on a file by file basis.

If your users have Windows XP, then this might be helpful...

http://www.microsoft.com/windowsxp/u...rlanguage.mspx

I think you can do something similar in Vista too (but I don't have a link
for it).

Rick

Tom and Rick. Thanks a lot for the links, I appreciate the suggestions.

"Rick Rothstein (MVP - VB)" wrote:

> > Most of the users who work with the spreadsheet work on English and French
> > files with different copies of the workbook. They have their regional
> > settings at English, but when they need to work on a French file they need
> > to
> > switch the Regional settings to get the currency format correct. I was
> > looking for a way to provide them with a macro so they could switch the
> > Decimal Symbol from within excel (without having to adjust the regional
> > settings) on a file by file basis.
>
> If your users have Windows XP, then this might be helpful...
>
> http://www.microsoft.com/windowsxp/u...rlanguage.mspx
>
> I think you can do something similar in Vista too (but I don't have a link
> for it).
>
> Rick
>
>