hi,
this is simple but found no answer yet (like some guy at http://www.mrexcel.com/forum/showthread.php?p=601502)
the idea is to copy decimal values to userform and back to the original cell when working with coma as the decimal sign (0,15 and so on)
for some reason the value is passed as 0.15 to the userform and when is copied back to the cell the dot is not understood as a decimal sign and so decimal digits become regualr digits making it a huge number and messing everything
I could use Replace to change the dot into a coma but I amb affraid of what will happen if a user works with . as decimal sign --- is there no foolproof solutino to that?
thanks in advance
Bernat
Bookmarks