I was making a form where the user could enter a number; eg. 4.61
However, depending on the user's background he might enter this as 4,61 (comma) or as 4.61
In the form this variable comes in as a string. How can I convert this in VBA to a digit if I don't know in advance if the users system uses a . or , as the digit-seperator??
Any help would be very grateful
I thought that in access you can actually predefine the type that is entered into the form but I don't believe this is possible in Excel (or at least i could not find something like that)
thanks for the help
<snip by admin. Read the rules you have agreed to or you may be banned>