Hi all,
I have a pretty annoying problem. When I transport values from an excelsheet to a Notes-document I get the strangest behaviour: if the number is a decimal-number Notes interprets the content as two separate values in stead of one decimal-value (since I live in Denmark comma is our decimal-delimeter - that might explain some of the problem…).
Has anyone out there got any idea as to what is going on ? I feel that I’ve searched high and low with no luck.
Thanks for your time
Kim
Subject: Multivalue-content in singlevalue field
you can try reading it in as string and then converting it yourself…
i have had issues with regional settings b4…either do that, adjust your excel sheet b4 you do the import
Subject: Multivalue-content in singlevalue field
I don’t know how you are “transporting” the Excel data into Notes, but if a field is multi-value with a comma separator, then Notes will split data in the field into separate values each time it finds a comma. You can change the separator: for a field that contains numbers, the logical separator would be “space”.