Assuming the "0" is actually part of the cell's value and not put there by
Cell Formatting, then try this formula...

=MID(B1,1+(LEFT(B1)="0"),99)

and copy it down as needed.

--
Rick (MVP - Excel)


"Steved" wrote in message
...
Hello from Steved

Oops I forgot to check my column, the below does not remove the first "0"

=MID(B35,1,LEN(B35))

Thankyou.



"Steved" wrote:

Hello from Steved

I looked at other answers to my query

=MID(B35,1,LEN(B35))

Thankyou.

ps Can the above be done in VBA please.



"Steved" wrote:

Hello from Steve Dee

Please I would like to only remove first digit if it is a "0" In Col
B:B.

Yes their are more digits in a row in Col B:B

Yes some have digit starting at "1" to "9" which I need to stay

Yes their is 1 Character only "X" which I need to stay

I thankyou