Keith, The formatting that I shared works fine for USA phone numbers. I’ve used it for many years for tracking a list of contact information of a fantasy football league.
Steve Sent from my iPhone > On Feb 24, 2022, at 6:53 PM, Keith N. McKenna <keith.mcke...@comcast.net> > wrote: > > In article <64a75984-4f03-422e-7ccb-0358112cb1f6 > @verizon.net>, wa.two...@verizon.net.INVALID says... >> >> 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. > > Format the cell as text and enter the characters as you > want them to be displayed. trying to enter it as a number > format will not get you to where you want. As Brian > stated, Entering the way you want are not numeric values, > but text. > > Keith N. McKenna > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
