Some success here ....
I have made a mental note of the resultant Format code line after
highlighting the most recently added/available format, i.e., " F_o_rmat
-+1 () -1234) ". Also, I noticed that what appears within the _F_ormat
code line is NOT what I had entered. The Comment line shows what I expected.
What I typed into the cell is: 1112223333. ( NumLk is enabled ). The
resultant display within that cell is +1 (111) 222-3333, which is
absolutely acceptable to me.
I must figure a way to convert existing cell contents such as (877)
300-1111 to the desired display format. Can this task be accomplished
using a formula?
I think I saw a toolbar feature that converts to numbers, but that might
have been within LibreOffice, not AOO. Two clicks in LO changed the
existing data to 1234567890 format, and from there, I applied the
desired display format, as shown in image included above. Ultimately, I
want to be able to use LO or AOO for USA Telephone Number formatting.
Then, I must deal with very few international telephone numbers within
my Calc file.
TIA.
On 2/27/2022 12:58 PM, Vince@Verizon wrote:
My thanks to all that have replied. It has been wild here with home
repair concerns, or I would have acknowledged sooner.
I will attempt 1^(###)^###-#### (where ^ is a space) under the numbers
tab, when time permits.
1. I believe that as soon as I begin typing into the definition box, it
becomes "User Defined". Is that normal?
2. If I choose to edit the comment line, e.g., USA Telephone Numbers,
will my revision then appear in the selection box-right side, above
the definition box?
I hope that these characters are displayed correctly in the actual
posted message; sometimes, somehow, things get jumbled up.
Regards, VinceB.
