enforce a certain decimal point to cells

[associates]

Hi,

I wonder if there is a way of enforcing user to enter numbers in cells in a half decimal or (0.5) block. For example, user can enter any decimal numbers with only one decimal point such as 1.5 or 2.0 or 7 or 8.5, etc. But it will prompt user for re-entering the number when they enter something like 1.7 or 1.3. If user wanted to put in 1.7 to a cell, he/she is allowed to enter either 1.5 or 2 - nothing in between is allowed. I was trying to use the data validation but no option that can do that.

Any helps would be greatly appreciated.

uses Office 03

Thank you in advance

[shg]

Data validation formula: =int(2*Me) = 2*Me, where Me is replaced by the address of the cell in which it appears.

[Trebor76]

Or another (similar) way would be to use this Data Validation formula (assumes the first cell is A2, change as required):

Please Login or Register  to view this content.

[associates]

It works very well. Thanks to you both, shg and Trebor76.

Sorry, if i may ask again. I wonder if it is possible to add more than one data validation to the cells. Just realised i already have one data validation set to the cells but wanted to add another one to them.

Thank you in advance

[shg]

Yes, it is. What's the other condition?

[associates]

Thank you, shg for your reply.

Sorry for the delay in getting back to you.

The other validation i wanna add is the number entered to cells must be between 0 and 8.

Thank you in advance