That would be the '2' in your STR function.
STR(PII,3,
2)
That is the length of the number after the decimal point.
STR(PII,3,
0) ... should be what you are after.
The '3' if the minimum number of characters in the string.
It will automatically increase them if you have a larger number and will pad with spaces if you have a smaller number.
So you could actually try ... STR(PII,
1,0)
Barry.
One of the forum moderators.
Versions 6.5 to 27
i7-10700 @ 2.9Ghz, 32GB ram, GeForce RTX 2060 (6GB), Windows 10
Lenovo Thinkpad - i7-1270P 2.20 GHz, 32GB RAM, Nvidia T550, Windows 11