If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
condditional farmulation
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 |
#2
|
|||
|
|||
condditional farmulation
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 |
#3
|
|||
|
|||
condditional farmulation
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 news 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 |
Thread Tools | |
Display Modes | |
|
|