question Prevent ServiceNow from rounding up values when importing to currency field in SPM forum https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047931#M36398 <P>Hi,</P> <P>I need to import data from an excel speadsheet into 2 fields of the currency type.</P> <P>A few of the values contain digits after the decimal point.&nbsp; However when i do the import, ServiceNow is rounding off the decimal points so that each new value in the field ends in .00.</P> <P>How do I prevent this from happening?</P> <P>E.g.</P> <P>605.11 becomes 605.00</P> <P>713.76 becomes 714.00</P> <P>Any ideas?</P> Fri, 26 Oct 2018 11:52:52 GMT pierrep1 2018-10-26T11:52:52Z Prevent ServiceNow from rounding up values when importing to currency field https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047931#M36398 <P>Hi,</P> <P>I need to import data from an excel speadsheet into 2 fields of the currency type.</P> <P>A few of the values contain digits after the decimal point.&nbsp; However when i do the import, ServiceNow is rounding off the decimal points so that each new value in the field ends in .00.</P> <P>How do I prevent this from happening?</P> <P>E.g.</P> <P>605.11 becomes 605.00</P> <P>713.76 becomes 714.00</P> <P>Any ideas?</P> Fri, 26 Oct 2018 11:52:52 GMT https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047931#M36398 pierrep1 2018-10-26T11:52:52Z Re: Prevent ServiceNow from rounding up values when importing to currency field https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047932#M36399 Is this via a simple import or a transform? Sun, 28 Oct 2018 12:30:17 GMT https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047932#M36399 Jace Benson 2018-10-28T12:30:17Z Re: Prevent ServiceNow from rounding up values when importing to currency field https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047933#M36400 Hi, Please use below link https://community.servicenow.com/community?id=community_question&amp;sys_id=ecf683e5db1cdbc01dcaf3231f96191a Mark this answer as correct and helpful. Regards, Manjusha Bangale Sun, 28 Oct 2018 19:35:43 GMT https://www.servicenow.com/community/spm-forum/prevent-servicenow-from-rounding-up-values-when-importing-to/m-p/1047933#M36400 manjusha 2018-10-28T19:35:43Z