Setting the cell format to “Text” and entering the number exactly as you want it to look should do the trick, though the use of brackets (and maybe some other characters?) will give an invalid formula correction warning to which you will have to respond “No”. The resultant text does not have to be left justified, you can select the justification you want in the top menu bar, as normal. However the number entered as text will be text, you will not be able to do any numerical operations with it.
You can also enter a number as text without setting the cell format to text by typing ="123 456” (with your number of course, not 123 446) PCS > On 24 Feb 2022, at 12: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. >
