At 21:33 23/02/2022 -0500, Vince Bonly wrote:
How do I format cells for entry of USA Telephone Numbers, as: 1 (###) ###*-*####
I don't understand those asterisks; I'm assuming you don't mean them.
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.
What's wrong with "1 (000) 000-0000" (no quotes, of course)?
Should I be formatting these cells as "text" (left-justified) rather than as numbers (right-justified)?
You don't have control over this if you set a user-defined format in this way - and OpenOffice will think they are numbers. But telephone numbers are definitely really text, not numeric values. If you don't believe this, ask yourself the significance of someone else having exactly twice your phone number - or of your number being even and your friend's odd. You can set alignment independently of this anyway.
If you really wanted those peculiar asterisks, you would have to escape each of them with a backslash, as \*
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org For additional commands, e-mail: users-h...@openoffice.apache.org
