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