Generalhttps://www.infopathdev.com:443/forums/41.aspxIf you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.enCommunityServer 2007 SP3 (Build: 31118.962)Re: Issue with a decimal fieldhttps://www.infopathdev.com:443/forums/thread/53600.aspxMon, 12 Apr 2010 19:53:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53600ErnestoM0https://www.infopathdev.com:443/forums/thread/53600.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=53600<p>Hello!</p><p>One option is to use Data Validation, and simply prevent people from entering non integer characters. That is, force them to only enter integers.</p><p>Another option is to split this into two fields: one field for the numbers before the period/comma, and then one field for the two digits after the decimal <br /></p><p>Finally, you could try some wacky substring commands as in the attached form.</p><p>Good luck! <br /></p>Issue with a decimal fieldhttps://www.infopathdev.com:443/forums/thread/53516.aspxFri, 09 Apr 2010 11:02:49 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:53516Svetoslav0https://www.infopathdev.com:443/forums/thread/53516.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=53516<p>Hello all I am having an issue with a field formated as decimal(double) Since my template is for global use, I have formatted the field to ignore thousand separation, and only 2 position after the decimal comma to be active (apply this due to cents). Recently I have noticed that I have missed something very important. I suppose that for the IP product, there exist two types of general formats. US and EU US: uses &quot;.&quot; - decimal point and &quot;,&quot; for thousands separator (grouping symbol) EU: uses &quot;,&quot; - decimal comma and &quot;.&quot; for thousands separator (grouping symbol)</p> Now I am experiencing a problem since users are using the form with both standarts (EU and US). And as you can imagine it causes me problem. I cannot understand if it is 55.55 (fifty five euros and 55 cents) or it is 5555 Euros.. Related to this how can I solve the problem. If I convert the field how will it be affected (converting to integer). I think it will give me validation errors if there are cents entered. I think I can iliminate cents if I use roudning but will it convert the number to integer..Very interesting question I think.