View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mats Samson Mats Samson is offline
external usenet poster
 
Posts: 112
Default Textbox input interpretation

Hello,
in Sweden it's common to use the comma as a decimal delimiter and the period
as thousand delimiter. I have the Regional and Language Options set
accordingly. Textboxes though treats a number written as 1.234,56 as text as
default formatting is ##,##0.00.
It creates formatting problems reading numbers from cells into textboxes and
vice versa.
Can it be solved?
Regards
Mats