Hi folks, here's an easy one:
I have a two columns of data that I need to format the same way in order to make a formula work:
A
00300127877
00300034277
00300194885
00300201116
B
00300127877
00300192264
00300016779
00300178541
My question is: How can I eliminate the two zero's in front of all these numbers??
Thanks alot!
I have a two columns of data that I need to format the same way in order to make a formula work:
A
00300127877
00300034277
00300194885
00300201116
B
00300127877
00300192264
00300016779
00300178541
My question is: How can I eliminate the two zero's in front of all these numbers??
Thanks alot!