Maintaining 2 places in decimal calculation

I am trying to calculate subtotals for a cart application and when the total is say 12.90 the ouput reads as "12.9". It's a decimal datatype. How can I get it to maintain the the full two decimal places? Should I be using a different data type?

DJDUH! - Nevermind. The "system.Curreny" datatype works just fine.

DJ
Wait - no that will return 12.9 instead of 12.90 as well. Sorry folks too much coffee this morning. So how do I get either the Decimal datatype or the Currency dataype to return the full two decimal places?

Dj
You should be able to use FormatCurrency(myVariable) and it will do the trick for you. This will format what the user sees on screen.

As far as SQL Server is concerned, I don't believe it matters. If you pass SQL a 12.9, it will be converted to 12.90, if your column is a money or smallmoney type.

Maybe you can help me perform a calculation (division) of money. The cents keep getting dropped from my equations.

If I divide $453 by 4 people, the result should be $133.25. I have tried several things and CANNOT get anything other than $133.00.

Any guesses?