How to delete zeros from the front of a number?
I use an inputbox to get a number in string. e.g. value = "0000234560"
I want to remove the first 4 zeros, so that value = "234560"
But my following code doesn't work. I need some help.
Repeat(loopnum, If(IndexOf("0", value)==1, SetValue(value, Take(value, 2)) ) )
I am wondering is the dependencies problem or what? Thanks you for your help.