Combobox changes the decimal commas to dots - How to prevent it?

G

Guest

Hi!

I have tried to use a combobox in selection between values which have a
decimal part. As I'm European I use commas as decimal separators. However
although in the selection list of combobox the decimal separator is comma,
the chosen value in the linked cell is written with a dot and so I cannot use
the value as as a source value for calculation. Why is this happening? Why
does the combobox change the decimal separator? The weirdest thing about this
is that sometimes the combobox has returned the right value with a comma as
decimal separator.

Can anyone help with this?

Thanks in advance,
Erkka
 
G

Guest

Microsoft doesn't like the Europeans. Yesterday somebody was sending the
European date formatt to a combo box and kept on getting the US format. The
solution was to convert to a string before sending the date to the combobox.
 
G

Guest

Finally got it working, just needed to change the source values to text with
=TEXT(a1;"0,00")

Thanks Joel for the tip!

-Erkka

"Joel" kirjoitti:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use commas as decimal separator 2
Decimal dot to Decimal Comma 3
Importing txt-file with "." (= dot) as decimal separator doesn't w 2
Change Dots into Commas as Decimal Divider 2
Decimal point/comma issue 3
How do I change the way the decimal separator displays? 2
Wrong import of float data 2
Urgent - make formula work with both decimal separators 1

Top