To format a ten digit number as (555) 555-1212 use the following format code
(###) ###-#### Enter the ten digits into the cell, e.g. 1234567890, and the number will be displayed as (120) 456-7890 NOTE: area code must not start with zero. Zero in any other position will maintain the format. There is a space between the right paren ) and the next #. To enter only ten digits and have the US dialing prefix, +1 displayed use the following format code "+1" (###) ###-#### Enter the ten digits into the cell, e.g. 1234567890, and the number will be displayed as +1 (123) 456-7890 NOTE: there must be a space between the second quote " and left paren (. If there is no space then the formatted result will be +1(123) 456-7890 On Wed, Feb 23, 2022 at 9:33 PM Vince@Verizon <wa.two...@verizon.net.invalid> wrote: > Hi: > > How do I format cells for entry of USA Telephone Numbers, as: 1 > (###) ###*-*#### > > whenever, for example,I have typed a ten-digit number, e.g., 1234567890 > (no spaces, no negative/minus sign, no parenthesis, by use of the number > keypad (NumLk is enabled). > > Yes, I want the "1" prefix, the area code to appear within parenthesis, > and a negative/minus sign between the 3rd digit and the 4th digit. A > space follows the prefix "1" and a space follows the closing parenthesis. > > I have tried to set a user defined number-format, but am getting strange > results with apostrophes and/or double quote markings mixed in when > viewing the Format Cells dialogue, e.g., (#") "###"*-*"####. And, I > don;t understand why that is. I was hoping to find a pre-defined/default > format for use when entering USA telephone numbers. I am flexible; I can > probably do without the "1" prefix and/or the parenthesis. > > Should I be formatting these cells as "text" (left-justified) rather > than as numbers (right-justified)? > > Regards, > > VinceB. > > -- Alan Boba CISSP, CCENT, ITIL v3 Foundations 2011