There are many solution to your problem, one of them is

select the cells for which you want enforce 11 digit number, right
click-format cells- select custom- type in 0000000000#, click ok.


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=379683