ExcelBanter - Data Validation Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Validation Query (https://www.excelbanter.com/excel-discussion-misc-queries/153652-data-validation-query.html)

SiH23

Data Validation Query

Hi,

I would be most grateful if someone could offer some advice.

I need to set some kind of validation on columns to only except a 10 digit
number and nothing else. For example if a 9 or 11 digit number is added an
error message is displayed. Is this possible?

Kind regards,

Simon.

Elkar

Data Validation Query

Set the ALLOW field to "Custom" then enter this formula:

=AND(ISNUMBER(A1),LEN(A1)=10)

Change A1 to reference the active cell in whatever range you are using.

HTH,
Elkar

"SiH23" wrote:

Hi,

I would be most grateful if someone could offer some advice.

I need to set some kind of validation on columns to only except a 10 digit
number and nothing else. For example if a 9 or 11 digit number is added an
error message is displayed. Is this possible?

Kind regards,

Simon.

All times are GMT +1. The time now is 02:21 PM.