P
pcw
I want to display values in the following manner --> if a
respondent enters a decimal place it will automatically
chop the decimal place without rounding the number up
(for example, 49.9 will display as 49 instead of 50).
At the same time I want to be able to have -49.9
recognized as a number.
What format would be good for this? There must be a way
to customize/format the cell to do both of these things.
Thanx in advance.
respondent enters a decimal place it will automatically
chop the decimal place without rounding the number up
(for example, 49.9 will display as 49 instead of 50).
At the same time I want to be able to have -49.9
recognized as a number.
What format would be good for this? There must be a way
to customize/format the cell to do both of these things.
Thanx in advance.