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
