Menu
How to select rows having value more than 2 decimal places?
For example we have these values:
3.14
5.999
9.555
8.55
And i want to select these values only:
5.999
9.555
467
Select the cells that you want to format. On the Home tab, click Increase Decimal or Decrease Decimal to show more or fewer digits after the decimal point.
Just use %. 2f as the format specifier. This will make the Java printf format a double to two decimal places.
The ROUND() function rounds a number to a specified number of decimal places.
You can use _ as a single-character wildcard with LIKE
LIKE '%.___'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
