SharePoint Create List Item Removes .00 Decimals
Posted on 2012-09-19
I have created a Doc Library in SPD 2010 and created a Document Content type which I have then editied the template for so I can push the fields through using Words Document Properties Quick Parts.
I have then created an Approval Workflow which, when Approved, creates a document in the Doc Library and sets the Doc Properties in the doc to the same as the form fields.
Some of the fields are used to hold financial figures. Most of these have been set as a Currency field with 2 decimal points but one of them has been set as a Single Line of Text field - as it's held within a Repaeting Table.
If I set the figues as (for example) 100.26 it pushes this through to the Word doc fine. If I set it as 100.00 it will be displayed in Word as just 100.
I'm guessing this must be some kind of AutoCorrect when creating the Doc and setting the field but I can't figure out how to change this.