Search code examples
excel-formulaexcel-2010excel-2007

Remove leading 3 zeros in Excel

Unsure if this is the right platform to ask this...

I want to remove the leading 3 zeros from a column in Excel.

The numbers in the column look like this:

000123456-001
000023568-001
000568975-001
000000235-001

I was able to format the column into text, but that's where I'm stuck. I don't see any way to format the cells to remove the first 3 zeros.

How do I remove the leading 3 zeros?

Solution

  • What about =RIGHT(A1,LEN(A1)-3)

    Would that work for you?