Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox changes the decimal commas to dots - How to prevent it?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox changes the decimal commas to dots - How to prevent it?
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. "Erkka" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox changes the decimal commas to dots - How to prevent i
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: 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. "Erkka" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change dots to commas!! | Excel Discussion (Misc queries) | |||
connecting dots on a chart | Excel Discussion (Misc queries) | |||
my printing comes out in dots instead of lines. | Excel Discussion (Misc queries) | |||
Change Dots into Commas as Decimal Divider | Excel Discussion (Misc queries) | |||
dots instead of grid lines | Excel Worksheet Functions |