Data Validation - allow multiples of ...

colmcg

Board Regular
Joined
Jul 2, 2004
Messages
101
Can anyone tell me how I can apply Data Validation to a cell to allow only a number EXACTLY divisable by 5 to be entered.

Thanks in advance.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

colmcg

Board Regular
Joined
Jul 2, 2004
Messages
101
Thanks, both of your suggestions work equally well. Now I'm spoilt for choice.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,013
Members
412,304
Latest member
citrus
Top