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
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
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,
I do not have the technical expertise to be able to decipher the error messages
generated by the system, and I believe they are intended to enable developers
to find bugs and fix them in future versions, not to enable you to be provided
with feedback, so for a glitch like you have described I
SEE BELOW ERRORS; TALKED WITH APPLE SUPPORT THEY SUGGESTED SENDING ERROR MESSAGE DIRECTLY. THIS MESSAGE HAS BEEN SENT BY OPEN OFFICE CLOSING SEVERAL TIMES AND SENDING ERROR MESSAGE TO YOU… SEE ATTACHED ERROR MESSAGE/>PLEASE, HELP FIX THIS PROBLEM, I HAVE BEEN USING OPEN OFFICE SINCE 2000; PREFER