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

Expected: 106.00 69.15 36.84
Actual: 106.01M 69.16M 36.85M


Problem 2

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

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

but when it goes without values when between (0.9 , -0.9) it result + % if the values between (+0.9,0) and -% if between (+0.9,0)

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

Suggestions and codes are welcomes, thanked and highly appreciated.


Thanks in advance.