Can anyone help with this?
Why not simply use the built-in Format option that has a comma as the decimal separator? That will allow you to enter the value directly with the comma, and will handle it correctly in later calculations.
Tried that. If I write 2,3 it gives me back 23.00?
What option did you select under the Format tab?
Also, make sure to remove the code you applied earlier, which removes the comma from the text...
Thanks for your tip. Actually right now all the Format tab options calculate right??? Nesa Nuranis code workes also. I don't know what happened, but thank you for your tips.
That's exactly what I suggested you do, but OK...
Yep, it just didn't work the first time I tried it. Maybe closing and re-opening the file did something and this suggestion started to work.
So you want to write 2,3 but field to show 2.3?
try this as custom format script:
event.value = event.value.replace(",",".");
If you want to write , and field to show , but to calculate as decimal try select this option:
This worked perfectly. Thank you very, very much!!