removal of first digit on left in cell
 

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?

removal of first digit on left in cell
 

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?

removal of first digit on left in cell
 

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?

removal of first digit on left in cell
 

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?