NumberFormat or Round2

[davelt99]

s="123.45"
s=NumberFormat(s,0,2) = "123.45"

s="123.00"
s=NumberFormat(s,0,2)="123"

Is there a way to force the ".00" for even dollar amounts ?

 

[klaus]

s=NumberFormat2(s, 0, 2, 2, False)="123"

Best regards.

 

[davelt99]

Thanks Klaus, wasn't aware of NumberFormat2