#1
|
|||
|
|||
Custom formatting code - rounding problem
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. |
Tags |
custom format, rounding |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Standard Dev. Rounding - Excel | judicial85 | Excel | 1 | 08-28-2011 05:41 PM |
Embedded Excel Graphs - Custom Formatting | Cody | Drawing and Graphics | 0 | 07-02-2010 02:30 PM |
Federal financial rounding? | markg2 | Excel | 6 | 05-26-2010 09:54 AM |
Custom menu keeps reverting back to old code | cookieboy66 | Word | 0 | 08-09-2009 03:44 AM |
Opening messages/Code/custom archive | jdd2 | Outlook | 0 | 12-20-2005 08:55 AM |