Custom formatting code - rounding problem

[venkys4u]

Here the problem raises with rounding the two decimal values. But i need like using trunc in custom formatting. I need the values not to get rounded with decimal but display as it was.

Problem 1

[>=1000000]$#0.00,, "M";[>=100000]$#0.00, "K";$#.00

this code converts millions and K with 2 decimals but it is rounding the first two digits

Values:106,008,784.41 69158976 36849808.41
when we divide by million we get the below values
[TABLE="width: 464"]
<colgroup><col width="167"><col width="147"><col width="150"></colgroup><tbody>[TR]
[TD="width: 167, align: right"]106.0087844
[/TD]
[TD="width: 147, align: right"]69.158976[/TD]
[TD="width: 150, align: right"]36.84980841
[/TD]
[/TR]
</tbody>[/TABLE]

Expected: 106.00 69.15 36.84
Actual: 106.01M 69.16M 36.85M (result of my code)


Problem 2

[>0] +##%;[<0]-##%;0

this code works as if it greater than 0 say 1, then display as +100% , lesser than 0 say -1 then -100% else 0

but it goes without values, when between (0.009 , -0.009) resulting like + % or -%. Say If the values between (0,-0.009) then resulting -%

( to simply the problem occurs when it is lesser then +or- 1 percentage)

So i need it to round 0 if the values between (+0.9,-0) and (0,-.9)

Suggestions , codes are welcome, thanked and highly appreciated.


Thanks in advance.
venky