Parse out zeroz

[Guest]

I am looking to separate out an apartment number. I have data that looks
like this 000030 and it stands for apt 30. Is there a way to parse out the
zeros so I can get to just the non zero numbers?

I know I would have to look at each space and see if it's a zero, but is
this easy?

Thanks!
RWI

 

[Guest]

if they are all zeros and numbers, just use the VAL(textstring) function