Those are either numbers formatted with leading zeros or text.

If the latter, to get rid of the leading zeros, re-format as General, copy an
empty cell and select range of numbers and editpaste specialaddokesc.

Now to deal with the trailing zeros...........do they all have 3 trailing zeros?

If so, enter 1000 in an empty cell and as above except use the "divide" option.


Gord Dibben MS Excel MVP

On Thu, 3 Apr 2008 11:24:00 -0700, octet
wrote:

I have field that have numbers with zero,s like this 0002764357000 i would
like to
format the column so that the zeros before or after any number are not shown
does anyone know how to do this?

thanks
octet