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
It is a floating point number, you have to tell it that: decimal d = Decimal.Parse(“1.2345E-02”, System.Globalization.NumberStyles.Float);
From this thread, there are different ways to do this: double r = 5.1234; System.out.println(r); // r is 5.1234 int decimalPlaces = 2; BigDecimal bd = new BigDecimal(r); // setScale is immutable bd = bd.setScale(decimalPlaces, BigDecimal.ROUND_HALF_UP); r = bd.doubleValue(); System.out.println(r); // r is 5.12 f = (float) (Math.round(n*100.0f)/100.0f); DecimalFormat df2 = new DecimalFormat( “#,###,###,##0.00” ); … Read more
public static String currencyFormat(BigDecimal n) { return NumberFormat.getCurrencyInstance().format(n); } It will use your JVM’s current default Locale to choose your currency symbol. Or you can specify a Locale. NumberFormat.getInstance(Locale.US) For more info, see NumberFormat class.
String.format(“%03d”, 1) // => “001” // │││ └── print the number one // ││└────── … as a decimal integer // │└─────── … minimum of 3 characters wide // └──────── … pad with zeroes instead of spaces See java.util.Formatter for more information.
Yes remove the commas: let output = parseFloat(“2,299.00″.replace(/,/g, ”)); console.log(output);
You can use format function with “,”; int no = 124750; String str = String.format(“%,d”, no); //str = 124,750 “,” includes locale-specific grouping characters. docs
The CSS working group has publish a Draft on Content Formatting in 2008. But nothing new right now.
You might want to look at the DecimalFormat class; it supports different locales (eg: in some countries that would get formatted as 1.000.500.000,57 instead). You also need to convert that string into a number, this can be done with: double amount = Double.parseDouble(number); Code sample: String number = “1000500000.574”; double amount = Double.parseDouble(number); DecimalFormat formatter … Read more
Try this SELECT CONVERT(DECIMAL(10,2),YOURCOLUMN) such as SELECT CONVERT(DECIMAL(10,2),2.999999) will result in output 3.00