I've found a strange format problem when I enter a value in a textbox
on a form.

If I enter value 5,5 in the textbox on the form, it is saved as value
5,5 in cell L14.
If I enter value 5.5 in the textbox on the form, it is saved as value
5,5 in cell L14.

The problem is that I can use the value in L14 in a sum function in the
second alternative, not in the first, although it looks like they are
saved as 5,5 in both cases.

This application is going to be used by people all over the world with
both decimal and dot separators so I have to find a generic solution
for both.

Can anyone help me with a solution?

// S