You hit it.
You're trying to use European data in a UScentric workbook. Excel looks at
your Windows settings. 3 ways to avoid this are (1) to get your European
counterparts to work in US style (unlikely), (2) to change your settings when
you absolutely have to use their data in their local format, (3) get VBA to
make the adjustments for you.
HTH,--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Excelerate-nl" wrote:

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