Looking for som help with a calculation.
I have numbers with leading zero's I need to be able to strip them away. Here is the catch I have some that have 1 or 2 leading zeros and some that could have more than 2 but no more than 6 leading zeros.
I will need them to look like this
It is one field in the Database.
If there is a better way than a calculation, I am open to sugestions.