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

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.

[macropod]

There is a limit to what you can achieve with formatting alone. AFAIK Numeric formatting always rounds to the nearest displayed precision level. If you're not satisfied with what you're seeing, you'll need to use a formula or edit the data.