Thread: Convert input to numeric
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Johnson Ken Johnson is offline
external usenet poster
  
Posts: 1,073
Default Convert input to numeric

wrote:
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

Reply With QuoteReply With Quote