Forum Discussion
How do I add "1" before phone numbers on excel
The phone number that I exported to excel sheet do not have (1) in front of them, so how do add that number?
9 Replies
The phone number that I exported to excel sheet do not have (1) in front of them, so how do add that number?
That very much depends on how your phone numbers are stored. Are they stored as numbers with the special formatting of a phone number? Or are they stored as text (numbers, yes, but stored as text)?
One way to tell is if you make the column in which they appear wide enough, phone numbers stored as numbers will line up to the right; phone numbers stored as text line up on the left. See below
If it's text (the second example above), then you write a formula in an adjacent cell that just concatenates "1 " with the phone number: ="1 "&A4
If it's a number, formatted as a phone number, you can use the number formatting dialog box
and select "More Number Formats" from the bottom of that range of choices, then "Custom"
And create your own custom format and apply it to the cells containing the phone numbers without the 1
See the attached sample spreadsheet
mathetes So if I wanted to change the number from (352) 123-4567 to 1(352)123-4567, then I type the following: "1"(352)123-4567? I tried that and it did not work
By the way, did you look at the sample file I attached in my first reply?
I demonstrated both possible solutions. That file, plus the explanations in that first answer, is fairly complete. Either part by itself, though, is incomplete,
