https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/42114.aspxWed, 27 May 2009 06:27:50 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42114Patrick Halstead0https://www.infopathdev.com:443/forums/thread/42114.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=42114<p>I would just write a little code or script to round the number up and convert it to a string.</p>https://www.infopathdev.com:443/forums/thread/42068.aspxTue, 26 May 2009 18:05:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42068mbrady19730https://www.infopathdev.com:443/forums/thread/42068.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=42068<p>Hello,</p> <p>I am having trouble converting my decimal to a whole number. My SQL database has the column stored as &quot;decimal&quot;. In infopath, I can only use the decimal numbers. I would like to be able to view the drop-down in whole numbers instead of decimals. The end user does not want to do the conversion in their head. Instead of displaying .05 in the dropdown, I wouyld like for it to show as 5 %. How can I format this, and make my formula recognize this?</p>