G
Guest
If use a VBA form to fill out data which sometimes have a decimal separator.
In Europe the comma is used as a decimal sign. However when I use a comma the
value is interpreted as a text when the macro places the value in the
spreadsheet. Only when I use the decimal point in the VBA form, the value is
accepted as a value in the spreadsheet.
Does this have to to with the MS Window settings or is it releated to my
english Excel version?
How can a prevent this problem without going into VBA code to tackle it?
Thanks in advance
Jan Bart
In Europe the comma is used as a decimal sign. However when I use a comma the
value is interpreted as a text when the macro places the value in the
spreadsheet. Only when I use the decimal point in the VBA form, the value is
accepted as a value in the spreadsheet.
Does this have to to with the MS Window settings or is it releated to my
english Excel version?
How can a prevent this problem without going into VBA code to tackle it?
Thanks in advance
Jan Bart