I’m using a textbox grid question type. The percent validation answer format seems to allow respondents to enter whole numbers (e.g. 1%) as well as decimals (e.g. 0.25%). I’ve been asked to have the validation be a percent and have two decimal points. As an illustration, some possible example answers would be:

- 0.25%
- 1.25%
- 1.00%
- 80.25%

And so on.

I can’t see an option to force the number of decimal points. Anyway to force two decimal points (even if they are .00)?

Thanks!

Thanks! It doesn’t seem to be working the way I had hoped but I appreciate your response.

Well, I couldn’t figure out how to get my post past the AnsPress filter, so here is an image of what I meant to send:

I haven’t tested this, but if you use RegEx validation, the following RegEx pattern should work:

<code><span class="pun">^</span><span class="lit">0</span><span class="pun">*(</span><span class="lit">100</span><span class="pln">\.</span><span class="lit">00</span><span class="pun">|[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]?[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]</span><span class="pln">\.</span><span class="pun">[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]{</span><span class="lit">2</span><span class="pun">})%</span><span class="pln">$<br /><br /></span></code>it breaks down as:<br />^0* = starts with any number of leading zeros (including none)<br />( = start a grouping. This is used here to group the two things seperated by the "or" <br />100\.00 = match exactly 100.00<br />| = or<br />[0-9]? = zero or one occurrences of a character between 0 and 9<br />[0-9]\. = a character between 0 and 9 followed by a period<br />[0-9]{2} = exactly 2 occurrences of any character between 0 and 9<br />) = end the grouping for the "or"<br />%$ = ends with a percent sign<br /><br />The following percentage strings will NOT match:<br />.10% (must have a character before the period)<br />99.00 (must have the percent sign)<br /><br />The RegEx could be altered if you wanted the above two example to work to something like:

<code><span class="pun">^</span><span class="lit">0</span><span class="pun">*(</span><span class="lit">100</span><span class="pln">\.</span><span class="lit">00</span><span class="pun">|[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]?[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]?</span><span class="pln">\.</span><span class="pun">[</span><span class="lit">0</span><span class="pun">-</span><span class="lit">9</span><span class="pun">]{</span><span class="lit">2</span><span class="pun">})%?</span><span class="pln">$<br /><br /></span></code>

*×*