Properties can return anything they want to, but it’s going to need to return the correct type. private decimal _amount; public string FormattedAmount { get { return string.Format(“{0:C}”, _amount); } } Question was asked… what if it was a nullable decimal. private decimal? _amount; public string FormattedAmount { get { return _amount == null ? … Read more
Another option (If you are using ASP.Net razor view) is, On your view you can do <div>@String.Format(“{0:C}”, Model.total)</div> This would format it correctly. note (item.total is double/decimal) if in jQuery you can also use Regex $(“.totalSum”).text(‘$’ + parseFloat(total, 10).toFixed(2).replace(/(\d)(?=(\d{3})+\.)/g, “$1,”).toString());
BigDecimal all the way. I’ve heard of some folks creating their own Cash or Money classes which encapsulate a cash value with the currency, but under the skin it’s still a BigDecimal, probably with BigDecimal.ROUND_HALF_EVEN rounding. Edit: As Don mentions in his answer, there are open sourced projects like timeandmoney, and whilst I applaud them … Read more
I’d recommend using the java.text package: double money = 100.1; NumberFormat formatter = NumberFormat.getCurrencyInstance(); String moneyString = formatter.format(money); System.out.println(moneyString); This has the added benefit of being locale specific. But, if you must, truncate the String you get back if it’s a whole dollar: if (moneyString.endsWith(“.00”)) { int centsIndex = moneyString.lastIndexOf(“.00”); if (centsIndex != -1) { … Read more
The HTML entity for the Indian rupee sign is ₹ (₹). Use it like you would © for the copyright sign. For more, read Wikipedia’s article on the rupee sign.
You can get currency conversions in a simple format from yahoo: For example, to convert from GBP to EUR: http://download.finance.yahoo.com/d/quotes.csv?s=GBPEUR=X&f=sl1d1t1ba&e=.csv
Consider simulating an input field with a fixed prefix or suffix using a span with a border around a borderless input field. Here’s a basic kickoff example: .currencyinput { border: 1px inset #ccc; } .currencyinput input { border: 0; } <span class=”currencyinput”>$<input type=”text” name=”currency”></span>
You only use the M for a numeric literal, when you cast it’s just: decimal dtot = (decimal)doubleTotal; Note that a floating point number is not suited to keep an exact value, so if you first add numbers together and then convert to Decimal you may get rounding errors. You may want to convert the … Read more
If you are looking for a one-size-fits-all, I’d suggest DECIMAL(19, 4) is a popular choice (a quick Google bears this out). I think this originates from the old VBA/Access/Jet Currency data type, being the first fixed point decimal type in the language; Decimal only came in ‘version 1.0’ style (i.e. not fully implemented) in VB6/VBA6/Jet … Read more
See the locale module. This does currency (and date) formatting. >>> import locale >>> locale.setlocale( locale.LC_ALL, ” ) ‘English_United States.1252’ >>> locale.currency( 188518982.18 ) ‘$188518982.18’ >>> locale.currency( 188518982.18, grouping=True ) ‘$188,518,982.18’