Bad copy on that last one:

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

c4db097?lnk=st&q=change+regional+setting+group%3Am icrosoft.public.excel.programming&rnum=22#9855b0cd 1c4db097

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