Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

photon · 05-15-2009, 03:54 PM

I think first you need them all as just numbers without any characters in them, so you could use substitute I think.. Create a column beside it, and set the formula as =SUBSTITUTE(A1,"-","") (assuming the column is A) then fill the formula down.. do the same for the ( and ) characters.. Or copy the column to a new worksheet and do a search and replace for those characters.

Once you've got it as all numbers, then create a custom format that's just ###-###-####

This won't handle phone numbers over 10 digits though.

05-15-2009, 03:54 PM	#2
photon The new goggles also do nothing. Join Date: Oct 2001 Location: Calgary Exp:	I think first you need them all as just numbers without any characters in them, so you could use substitute I think.. Create a column beside it, and set the formula as =SUBSTITUTE(A1,"-","") (assuming the column is A) then fill the formula down.. do the same for the ( and ) characters.. Or copy the column to a new worksheet and do a search and replace for those characters. Once you've got it as all numbers, then create a custom format that's just ###-###-#### This won't handle phone numbers over 10 digits though. __________________ Uncertainty is an uncomfortable position. But certainty is an absurd one.