View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default set the number of characters in a cell

Do you want to just show the leading 0's or does the cell actually have to
contain the leading 0's?

If you just want to show them, then you can select the range
format|cells|number tab|custom category
0000000000

Then use data|validation to make sure the entered value is a whole number
between 0(?) and 9999999999.



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