Is there a way to get rid of all the numbers except the last 2. The number
lengths vary from 6 to 8 digits?
Thanks
"Paul Sheppard" wrote:
If the numbers have varying numbers of characters you could use the
following formula to get rid of the 0's
If the number is in cell A1 then in cell B1 enter =MID(A1,1,LEN(A1)-2)
If the number is 01234500 it will return the value 012345
If the number is 012345678900 it will return the value 012456789
Paul
--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=391238