Getting decimal separator

I've tested both the suggestions above with Excel 2003, on a computer with standard system settings for Brazil:

Please Login or Register  to view this content.

always returns the character in the textbox for Decimal separator of the International tab of the Options form (regardless of whether the box for use system separators is checked or not).

Please Login or Register  to view this content.

returns the system wide decimal separator.

I have found this to be very important when working with code to modify formulas (range.formula), in which the decimal separator must always be ".", and not the system wide decimal separator. Here's some illustrative code:

Please Login or Register  to view this content.

With use system separators checked, and "." in the decimal separator box, I placed the value 2,36 ("," is my local system decimal separator) in cell D3, and the formula =D3*5,42 in cell E3. I then selected cell E3 and ran the macro above. Upon completion the contents of the cells were:

HTML Code: 

So for me:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Sincerely,

Richard.