Getting rid of zeros

[RWI]

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

 

[fredg]

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

If the number is stored as 000030 then it is a text value.
=Val([FieldName]) should return 30