sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

can you elaborate more in brief? are you looking for any consecutive numbers, when user entered the value say 3?

your kind help required..

"RAMAN" wrote:

sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell

Hi,

You may select the range where you want the user to enter the number and
then go to Data Validation Allow Whole Numbers and then specify the
range. Click on OK.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RAMAN" <RAMAN @discussions.microsoft.com wrote in message
...
sir, i want to do in excel such type of farmla through we can not leave
blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell