Hi,

You can also try Text to column - Fixed width.
To delete the Zeros from entire row.

Regards,

"Kipurr" wrote:

I have a column of numbers, as below. How can I remove the 0 in front?

035000
035002
035006
035009