Another way:

Put 10000000000 (with commas for easier reading: 10,000,000,000)
in an empty cell.
copy that cell
select your range of 10 digit phone numbers
edit|paste special|select the Subtract option.
Clean up that helper cell.





pc wrote:

How do I remove the leading 1 from a nine digit telephone #'s stored in a
column in excel. Eg. Get 17035551212 to be 7035551212

--

Dave Peterson