If I have a column with various numbers containing leading zero's (of different length), how can I get these leading zero's removed without removing any further zero's thereafter the first positive number in the cell
example
0000012340
0000006500
0007896541
I want these three cells to display as...
12340
6500
7896541
I can find no combination of =MID, Find and replace or =RIGHT that can do this for me
Please help
Regards
Matt
Bookmarks