Format number as money

Question

How do I format a number to look like this: 9,000 my database field is in money data type, when I pull it up I see it like this: 9000.0000 that don't look right to me (I would like it to look like a real money format)

Answer 1

While you could call string.format, I think it's easier to just call ToString on it.

decimal money = 9000m;
string formattedMoney = money.ToString("C");

Answer 2

decimal money = 1000;
Response.Write(string.Format("{0:C}", money));

The above is an example in C#.