View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson[_2_] Myrna Larson[_2_] is offline
external usenet poster
 
Posts: 124
Default Always convert to number

Check out the CDbl function.


On Sun, 31 Aug 2003 22:42:10 +0300, "GUS" wrote:

Is there Any code that convert any possible numeric input or a string to
number.(textbox input)

Some possible inputs may be

input wanted result
2343,44 2.343,44 (euro)
123.45 123,45
543534.44 543.534,44

I want that because some times users confuse the decimal separator
and some tmes they use comma and other times dot
So i want