"Number" stored in Sharepoint library column - InfoPath Dev
in

InfoPath Dev

"Number" stored in Sharepoint library column

Last post 12-07-2011 05:33 PM by Anson Hidajat. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 12-07-2011 09:49 AM

    • Sailor
    • Top 75 Contributor
    • Joined on 09-15-2009
    • Canada
    • Posts 107

    "Number" stored in Sharepoint library column

    Hello,

    I have a form where I there is a calculated field which I want to have available as a column in WSS 3.0.  The field is set as a Decimal type, and formatted for 2 decimal places (it's a currency 29.99).  The problem is when the value appears in the Sharepoint column it appears with 3 decimal places.  So instead of the CORRECT currency value of 94.98 the value is 94.975.

     The column type in WSS is Number but I can't click on it to change it.  

    How can I fix this?  THANKS!

  • 12-07-2011 05:33 PM In reply to

    Re: "Number" stored in Sharepoint library column

    If you have access to the settings on the list, go to Settings -> List Settings -> Click the number column -> Number of decimal places -> choose 2 from the dropdown.

    Hope this helps!

    Anson Hidajat
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.