As a guess some of your numbers are actually text and some are numbers. The
ones that are text will probably have a ' at the front of them. You probably
want to convert them all to a single data type, either text of number.
--
HTH...

Jim Thomlinson


"Michael" wrote:

I have created a contact sheet, but not all of the cells will display the
first zero of the phone number. Cells are all set the same, General Number.
Can any one help