Stop rounding off the numbers

[Elainefish]

I am making a form wherein the numbers to be entered has decimals
Some numbers has 2 decimals, some has 3, and so on

For ex:
16.10
16.100
(I know that it is the same number but it just needs to appear as how we enter it)


I cannot change the format into text because I have conditional formatting that the acceptable value is for ex 5≤ x ≤25

Any help?
Thanks in advance

[Kaper]

You cannot have a cake and eat it.
Well, in this case you probably can .
Use text format which will store 16.100 as 16.100 not 16.1 but your conditional formatting rule cannot be just standard one. It has to be a rule based on formula (CF - new rule - use formula ...).
In the formula you first convert text to number (simple --A1 will convert text A1 into a number) and then compare with allowed range limits.
The formula for the CF rule could look like:

Please Login or Register  to view this content.

[Elainefish]

What if my condition is only ≤ 50?
I tried
=and(--A1<=50) but it is not working

You cannot have a cake and eat it.
Well, in this case you probably can .
Use text format which will store 16.100 as 16.100 not 16.1 but your conditional formatting rule cannot be just standard one. It has to be a rule based on formula (CF - new rule - use formula ...).
In the formula you first convert text to number (simple --A1 will convert text A1 into a number) and then compare with allowed range limits.
The formula for the CF rule could look like:

Please Login or Register  to view this content.

[Kaper]

if there is just one condition, AND is not nececessary.
See attached file (in DK, as I remember, you also use comma as decimal separator, don't you?)

If it's fine (or simply reversed - then reverse less than to greather than), you can play with excluding/including empty cells from/in formatting

try for instance:

Please Login or Register  to view this content.

PS. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.