Hi,

We have integer validations for some cells in our Microsoft Excel file which are working properly when we are typing the data (Showing error dialog when we enter non integer data).

But if I am copying the data from other source (for example other excel sheet), the validations are not working (it is allowing non integer data also).

Could anyone help me to solve this issue asap.

Thanks,

Zaheer

Hi,

If you are talking about copying data from excel to excel then check for the cell format....

--Manjunath

Hi zaheer_infy, 

Since this thread is not related to Excel Development (e.g.VBA). I suggest that you can post your question to TechNet Office Forum where you can get better help. 

Your cooperation will be highly appreciated. 

Regards, 

Jeffrey