Thanks for your reply. They want it this way to save space. Right now, it rounds off to 2 decimal places--so why have "Opportunity (2.00M)" when you can have "Opportunity (2M)". The three saved characters help keep the text on one line since the columns are side by side. Hence, by the time all opportunities are listed, the hope is that they fit on one page when it's exported as a PDF, word, etc.

Is there a way to accomplish this through a value expression in VB.net? I'm not familiar with TSQL, nor would I know where to start entering it. :/