What is the best way of dropping trailing 0's? I know there is a round function, but I do not want to round I want to TRUNCATE and REMOVE the 0's and leave 1 decimal point. For example:
Number 4.510000 I want to be 4.5
I have used the function command on ROUND but it still leaves the trailing 0000
NB The third parameter to ROUND is what you are looking for. This will not round up to 4.6 but rather truncate as you per your requirements.
answered Feb 19, 2012 at 01:47 PM