Android Question NumberFormat2

[kuosda]

log(NumberFormat2(-0.00000001, 1, 4, 0, False)) → -0
But what I want is 0 not -0
What can I do?

 

[Erel]

Are you only interested in positive values?

If so then you can use:

Log(NumberFormat2(Abs(value), 1, 4, 0, False))

 

[kuosda]

log(NumberFormat2(-0.1234, 1, 4, 0, False)) → -0.1234
So you can not use abs ()

 

[Erel]

This is why I asked whether you are only interested in positive values.

You can add this sub:

Sub RemoveSignedZero(d As Double) As Double
 If Abs(d) < 0.00001 Then Return 0 Else Return D
End SUb

Log(NumberFormat2(RemoveSignedZero(your number), ...))