Hi Ken, This was seems like it should be simple... I have a telephone column, in which values are mixed from (910) 334-4567, to 2125551212; I would like them all to come out solely digits - i.e. 9103344567, how can I do this? thanks,Monte
Monte Do a search and replace on the column to replace all the ( with nothing, then the ) with nothing, then the - with nothing. Then format the column with a custom format to make them all look like phone numbers. It is possible that they won't be recognized byas numbers after the replacements, in which case you will just have to multiply the column by 1. Then they will be recognized as numbers, and custom formats will work.