Number Format for .000 With No Leading Number
I have a number format such as the following:
.667
However, I’ve tried #.000, and I get 0.667. This should work, but it doesn’t.
I knew this wouldn’t work, but I tried .000, and it did not work.
What am I doing wrong to display a percent in decimal format without the leading digit unless the result is 1 (which would be displayed as 1.000)?
Quantrix Marketing Answered question
Hi @mgandy – Modeler will display the 0 in front of the decimal point. You might be able to create a custom number format though. You could create a new model to test some options. For example, you could try format code: ?.000
Here is where you can test this out:
Quantrix Marketing Posted new comment
Quantrix Marketing commented
Our engineering team came up with that suggestion!
You are a genius. That works. Just curious, how did you know to use the question mark?