I have a row of numbers that have one to many zero's. I need to remove the
first
zero on the left. Can this be done by a formula?

Penny,

With leading zeroes I assume these must be text. If they er try this

=MID(A1,2,LEN(A1))

Mike

"Penny" wrote:

I have a row of numbers that have one to many zero's. I need to remove the
first
zero on the left. Can this be done by a formula?

Sure, just use the following formula in another column, then copy from there
and paste special as values in the column with the error.

If A5:A3897 is the column with one too many zero on the left side, and
column I is empty, use the following formula in I5, then fill down to I3897.

=RIGHT(TRIM(A5),LEN(TRIM(A5))-1)

The TRIM function is included in case there's any leading/trailing spaces in
the values.

--
Thanks,

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Penny" wrote in message
...
I have a row of numbers that have one to many zero's. I need to remove the
first
zero on the left. Can this be done by a formula?

Numbers don't have leading zeros unless they are text.

Maybe they are numbers just formatted that way like Custom format of 000000

will return 001234 if 4 digits in cell. Remove one 0 from the formatting.



Gord Dibben MS Excel MVP

On Tue, 20 Jan 2009 13:48:04 -0800, Penny
wrote:

I have a row of numbers that have one to many zero's. I need to remove the
first
zero on the left. Can this be done by a formula?