Hello friends,
do you have any idea how can i remove zero values if its coming with value like 5.1 then its showing me 5.10 . i want to remove zero if its coming..
thanks in Advance
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Neha SharmaPosted Oct 17, 2012, 5:42 AM
Please find the attachment you ll solve your problem.
let me know the problem solved or not.
Thanks.
Naeem KhanPosted Oct 17, 2012, 5:32 AM
Neha SharmaPosted Oct 17, 2012, 4:26 AM
Naeem KhanPosted Oct 17, 2012, 4:01 AM
Sivaraman DhamodaranPosted Oct 17, 2012, 2:54 AM
Right click the filed, Select format field. (Previously I told property). From the displayed dialog move to all the tab. One tab will have different formats of decimal, chose the one (With No zero)
Naeem KhanPosted Oct 17, 2012, 2:12 AM
Sivaraman DhamodaranPosted Oct 17, 2012, 1:46 AM
Or
2) Write a formula, that will do the truncation when it finds a zero.