But you also allow ABCDEABCDE (because it's just based on length of the text).

The OP could still format the cell as text, then use:
format|conditional formatting
formula is:
=AND(LEN(A1)=10,ISNUMBER(-A1))

But this still allows non-numeric entries (darn scientific notation!):
12341234E1
But that may not be a problem for the OP.




Sloth wrote:

Format the cells as text first
The select the Data menu and choose Validation
Under Allow choose Text length
Under Data choose Equal to
Under Length type 10
Click OK

by numbers I assume you mean digits. This method will not allow 123456789,
unless you enter it as 0123456789. Dave's method will allow 123456789 and
then show as 0123456789. With his method though the result is still a
number. The result of mine will be a text string.

"CF" wrote:

How can I format a cell so that ONLY ten numbers can be entered; no less than
ten, and no more than ten can be entered. Also, some of these ten digit
numbers begin with a zero and I would like that zero to display as well as
count as one of the ten digits.

Thanks in advance for your help!


--

Dave Peterson