Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm using SPWeb.ProcessBatchData to update list items, and I'm having a problem with currency field. When I insert something like this

<SetVar Name=\"urn:schemas-microsoft-com:office:office#MyFiled\">2777,88</SetVar>

the value inserted into sharepoint list is 277 788,00. The comma is the correct delimiter for my locale settings (polish). I can't figure out the format, in which the value would be inserted properly. Any help would be appreciated.

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

ok, it seems that the solution is to return number as string and replace comma with dot - apparently with ProcessBatchData regional settings of the site are not used, so I had to provide the number with standard english-version format

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.