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
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
Vince,
1) Yes, it’s normal to switch to User Defined.
2) Not sure what you’re referring to.
Steve
Sent from my iPhone
> On Feb 27, 2022, at 11:58 AM, wa.two...@verizon.net.invalid wrote:
>
>
> My thanks to all that have replied. It has been wild here with home repair
> concerns, or I woul
At 13:08 27/02/2022 -0500, Vince Bonly wrote:
I must figure a way to convert existing cell contents such as (877)
300- to the desired display format. Can this task be
accomplished using a formula?
Yup: =VALUE(MID(Xn;2;3)&MID(Xn;7;3)&MID(Xn;11;4))
- where Xn is the cell containing the origi
