Getting rid of zeros

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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