Custom formatting code - rounding problem

I hope I am in a right forum.. else please re-direct or move this thread to a right one..


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 +100% , lesser than 0 say -1 then -100% 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)

To say simply problem comes when it comes lesser than 1% having values say 0.009 it is not showing any values so let us round to 0.

Suggestions and codes are welcomes, thanked and highly appreciated.


Thanks in advance.
venky

Thanks for ur time..

Could you please give some more details on this.. I am not versed in excel ..

Thanks for ur time shg!
I can use trunc function referring a cell manually .. but the problem is , in need of custom formatting code and without referring any columns

like

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

here i havent mentioned any cell as A1 so and soo..