Hi,
I need to redact the multiple 0s in front of numbers in like mentioned in the below table, can someone please help with the best way to do it?
No | Desired no |
0000012345 | 12345 |
0000123 | 123 |
000000123456789 | 123456789 |
001234567 | 1234567 |
Solved! Go to Solution.
Wow, just like that ..thank you so much @Luke !!
@SP3000 ,
I completely agree with @Luke_C on the trimleft() function. If you want a "NUMBER" you can also convert ToNumber() the entry and that will remove all of the multiple zeros naturally.
Cheers,
Mark