Convert input to numeric

[staeri]

I have a very difficult problem that seems to be to hard for me to
solve. We use VBA forms with textboxes for input.

I'm in need of a converting function which works in all countries,
especially regarding decimal sign and thousand separator.

If I'm in Sweden where we use "," as decimal sign I want to be able to
also use "." and convert this to a numeric value.

If I'm in US where we use "." as decimal sign I want to be able to also
use "," and convert this to a numeric value.

The reason why I want to allow both signs is that the entered value is
used for other calculations so I need it to be numeric.

All kinds of help is very appreciated!

Regards,

SE

 

[Ken Johnson]

I have a very difficult problem that seems to be to hard for me to
solve. We use VBA forms with textboxes for input.

I'm in need of a converting function which works in all countries,
especially regarding decimal sign and thousand separator.

If I'm in Sweden where we use "," as decimal sign I want to be able to
also use "." and convert this to a numeric value.

If I'm in US where we use "." as decimal sign I want to be able to also
use "," and convert this to a numeric value.

The reason why I want to allow both signs is that the entered value is
used for other calculations so I need it to be numeric.

All kinds of help is very appreciated!

Regards,

SE

Hi SE,

You might be able to make use of the example in VBA Help under
"DecimalSeparator Property"

Ken Johnson

 

[Ken Johnson]

Which is a property of the Application object (I left out)

Ken Johnson