tag:blogger.com,1999:blog-2509167754737584590.post5622459923055233398..comments2010-05-02T00:37:28.907+05:30Comments on Yogesh Gupta's Excel Tips: Excel Number Format : Telephone numbers with leadi...Yogesh Guptahttp://www.blogger.com/profile/08246342663404873564noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2509167754737584590.post-29001640768222863762010-05-02T00:37:28.902+05:302010-05-02T00:37:28.902+05:30Your question is not entirely clear to me. Do you ...Your question is not entirely clear to me. Do you have the numbers formatted (using Cell Format) in any way? If so, what is the format? If not, are the numbers constructed as text with the formatting hard coded into your numbers? Also, you say you recorded the steps... does that mean you are looking for a VB solution to physically add the "1" in front of your existing number as opposed to displaying the "1" via a custom format in the manner Yogesh outlined in this article?Rickhttp://www.blogger.com/profile/07572190007880814311noreply@blogger.comtag:blogger.com,1999:blog-2509167754737584590.post-77922413923008231942010-05-01T14:28:59.934+05:302010-05-01T14:28:59.934+05:30I have a large data base with telephone numbers, i...I have a large data base with telephone numbers, in a single column. I wish to add the number 1 to all the telephone numbers in the cells. When I record the steps, it copies the previous telephone.Stanleyhttp://www.blogger.com/profile/06393603374852487274noreply@blogger.com