Number check

[ZBH]

Hello,

I want have to enter a 8 digit number in a cell. How can i make Excel check this. For example if by mistake only enter 7 numbers.

Thanks

 

[Aladin Akyurek]

On 2002-02-18 22:47, ZBH wrote:
Hello,

I want have to enter a 8 digit number in a cell. How can i make Excel check this. For example if by mistake only enter 7 numbers.

Thanks

=ISNUMBER(A1)*(LEN(A1)=8)

or

=ISNUMBER(A1+0)*(LEN(A1)=8) [ if you're entering the number as text ]

You can use this formula, if so desired, in data validation that you can setup in cell A1.
This message was edited by Aladin Akyurek on 2002-02-18 22:56