Vince, If you want the format of 1 (123) 456-7890 simply type in the format definition box (near the bottom of the pop up menu for Format Cell under the Numbers tab) 1^(###)^###-#### (where ^ is a space). There is no need for quotation marks. You can put any text you want when you are defining the format of a number.
Make sure the width of the column is wide enough for all of the characters otherwise you’ll get the error code ### which signifies a number too wide to display. Steve Sent from my iPhone > On Feb 23, 2022, at 10:14 PM, PCS <pean...@bigpond.com> wrote: > > > 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. >> > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
