How to format a decimal number based on certain values in php

Question

I am having few values 99.00 99.90 99.01

FYI, I am already getting the above 3 values after having number_format($value, 2) applied to them

But now I want to strip the decimals without rounding them off such as 99.00 to 99 99.90 to 99.9 99.01 to 99.01 remains same

How can achieve this? Please devise me a way guys.

I just need a function which checks following:

Whether a given number is decimal i.e having "." and digits after decimal
Whether the last digit is 0, if yes, then get rid of the last digit
Whether both the digits after decimal points are 0, if yes, remove them.
If any of them are not 0, then they should remain there, like in case of 99.09 it should remain intact, in case of 99.90 it should be 99.9.

Awaiting your ideas. Thanks in advance.

If my answer solved your question, please mark my answer as accepted :) — user2342558, Jan 26 '18 at 15:29
Hard choice, there are three decent answers and ways to do it ;) — IncredibleHat, Jan 26 '18 at 15:33
https://stackoverflow.com/questions/4483540/show-a-number-to-2-decimal-places — Pramod Kharade, Jan 26 '18 at 15:57

user2342558 · Answer 1 · 2018-01-29T08:33:15.213

3

By adding 0 to the number, the rightmost zeros are removed:

$num1 = 99.00;
$num2 = 99.90;
$num3 = 99.01;
$num4 = 99.012;
$num5 = 99.0123;

$num1 = number_format(99.00,   2, '.', '') + 0;
$num2 = number_format(99.90,   2, '.', '') + 0;
$num3 = number_format(99.01,   2, '.', '') + 0;
$num4 = number_format(99.012,  2, '.', '') + 0;
$num5 = number_format(99.0123, 2, '.', '') + 0;

echo "$num1\n";
echo "$num2\n";
echo "$num3\n";
echo "$num4\n";
echo "$num5\n";

Output:

Try it here.

With a function:

function round2no0(&$num)
{
    $num = number_format($num, 2, '.', '') + 0;
}

usage:

$num1 = 99.00;
$num2 = 99.90;
$num3 = 99.01;
$num4 = 99.012;
$num5 = 99.0123;

round2no0($num1);
round2no0($num2);
round2no0($num3);
round2no0($num4);
round2no0($num5);

echo "$num1\n";
echo "$num2\n";
echo "$num3\n";
echo "$num4\n";
echo "$num5\n";

function round2no0(&$num)
{
    $num = number_format($num, 2, '.', '') + 0;
}

Output:

Edit:

Added , '.', '' parameters to number_format to handle also numbers with thousands maintaining the machine-format 12345.12.

Try it here.

edited Jan 29 '18 at 08:33

answered Jan 26 '18 at 15:22

user2342558

5,567
5
33
54

Your example is correct only if the desired result is with max 2 decimals. – user2342558 Jan 26 '18 at 15:28
@PramodKharade, the aim of your comment here?!? – user2342558 Jan 26 '18 at 16:01
I tried the above but there is issue with certain values such as 1 1 99.11 99 99 Notice that num1 and num2 are returning as 1 whereas I need it as 1,200 – Asnexplore Jan 27 '18 at 04:28
@Asnexplore see my edit: now it handles correctly also numbers with tousands. – user2342558 Jan 29 '18 at 08:31

score 2 · Answer 2 · answered Jan 26 '18 at 15:22

2

you should be able to just wrap it in a floatval()

answered Jan 26 '18 at 15:22

Jake Pogorelec

27
4

dhinchliff · Answer 3 · 2018-01-26T15:52:32.857

0

Try this:

echo round(99.001, 2), PHP_EOL;
echo round(99.901, 2), PHP_EOL;
echo round(99.011, 2), PHP_EOL;

Output:

99
99.9
99.01

edited Jan 26 '18 at 15:52

answered Jan 26 '18 at 15:32

dhinchliff

1,106
8
17

1

`number_format` rounds as well so I think Asnexplore was ok with it rounding. Your answer is the cleanest solution (all he needs is that, nothing more), no idea why the downvote. – IncredibleHat Jan 26 '18 at 15:41
1

@IncredibleHat You are right, he does do a rounding already so I removed the extra stuff I added. – dhinchliff Jan 26 '18 at 15:46
Yes, true the rounding etc. was all done. I need these results post that to cleanup the trailing 0 or 0s. – Asnexplore Jan 27 '18 at 04:19
Try with numbers like 1200.91, 1,200.00, 1,200.90, 1,200. They are showing as 1 if the comma is not there, but with commas they are generating an error message Parse error: syntax error, unexpected ',' in /tmp/execpad-edf220d84a3a/source-edf220d84a3a on line 2 – Asnexplore Jan 30 '18 at 09:36
Though I appreciate your hard work in helping me, unfortunately, it's still not doing what I wanted to have. – Asnexplore Jan 30 '18 at 09:37
That's because everything after the comma is ignored. Don't use commas, numbers don't have commas, you are using strings. The input should be number `1200.90` and not the string `1,200.90`. – dhinchliff Jan 30 '18 at 10:02

score 0 · Answer 4 · answered Jan 26 '18 at 17:27

If you use a custom notation with number_format, you can use preg_replace to remove the decimal point separator and trailing zeroes after it.

// Default notation
echo preg_replace('/\.?0+$/', '', number_format(9990.00, 2)); // "9,990"
echo preg_replace('/\.?0+$/', '', number_format(9990.90, 2)); // "9,990.9"
echo preg_replace('/\.?0+$/', '', number_format(9990.01, 2)); // "9,990.01"

// French notation
echo preg_replace('/,?0+$/', '', number_format(9990.00, 2, ',', ' ')); // "9 990"
echo preg_replace('/,?0+$/', '', number_format(9990.90, 2, ',', ' ')); // "9 990,9"
echo preg_replace('/,?0+$/', '', number_format(9990.01, 2, ',', ' ')); // "9 990,01"

How to format a decimal number based on certain values in php

4 Answers4