Decimal Symbol

D

dawson

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

Tom Ogilvy

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

dawson

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

Rick Rothstein \(MVP - VB\)

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.
Click to expand...

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

http://www.microsoft.com/windowsxp/using/setup/winxp/yourlanguage.mspx

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

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
How to print numbers invariably using dots as decimal symbol? 9
How to print numbers with dots, regardless of locale 8
Need to have a dot used as decimal symbol, regardless of locale 1
text box in userforms and international number format 0
Help with loop 4
Formatting Decimal Places 3
Converting decimal degrees to degrees, minutes & seconds 2

Top