Correction After applying the recommended format, (###) ###-####, and entering 1234567890 the displayed value will be (123) 456-7890.
No idea how/why I typed what's in my original answer. My apology for any confusion I may have caused. On Fri, Feb 25, 2022, 8:20 AM Alan B <abo...@gmail.com> wrote: > 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 > >
