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)(Xn;7;3)(Xn;11;4))
- where Xn is the cell containing the original
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
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
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
Jonathan,
Actually Vince’s (the OP) original question was about 1+ (###) ###- not +1
(###) ###-.
He also asked about (###) ###- as an alternative. Both were addressed
several responses ago including an incorrection in regards to those solutions.
Steve
Sent from my iPhone
> On
On 25/02/2022 19:58, Alan B wrote:
Correction
After applying the recommended format, (###) ###-, and entering
1234567890 the displayed value will be (123) 456-7890.
Your original question was asking about +1 (###) ###-, not (###)
###-.
jonathon
OpenPGP_0xA759EEC77A18EA38.asc
Correction
After applying the recommended format, (###) ###-, and entering
1234567890 the displayed value will be (123) 456-7890.
No idea how/why I typed what's in my original answer.
My apology for any confusion I may have caused.
On Fri, Feb 25, 2022, 8:20 AM Alan B wrote:
> To format
To format a ten digit number as (555) 555-1212 use the following format code
(###) ###-
Enter the ten digits into the cell, e.g. 1234567890, and the number will be
displayed as (120) 456-7890
NOTE: area code must not start with zero. Zero in any other position will
maintain the format. There
At 19:53 24/02/2022 -0500, Keith N. McKenna wrote:
Format the cell as text and enter the characters as you want them to
be displayed.
But that doesn't address the problem I understood the questioner to
be posing: he wants, I think, to be able to enter just the ten digits
and have the
At 10:17 24/02/2022 -0600, Steven Ahlers wrote:
It does drop a leading zero in the area code. It doesn't drop
leading zeros from the prefix series or the exchange series. In the
USA no area code starts with a zero so this would be a nonissue.
Ho, ho: indeed so!
But look what happens if the
Keith,
The formatting that I shared works fine for USA phone numbers. I’ve used it for
many years for tracking a list of contact information of a fantasy football
league.
Steve
Sent from my iPhone
> On Feb 24, 2022, at 6:53 PM, Keith N. McKenna
> wrote:
>
> In article
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,
Brian,
It does drop a leading zero in the area code. It doesn’t drop leading zeros
from the prefix series or the exchange series. In the USA no area code starts
with a zero so this would be a nonissue.
Steve
Sent from my iPhone
> On Feb 24, 2022, at 9:44 AM, Brian Barker
> wrote:
>
> At
At 09:18 24/02/2022 -0600, Steven Ahlers wrote:
If you want the format of 1 (123) 456-7890 simply type in the format
definition box (near the bottom of the pop up menu for Format Cell
under the Numbers tab) 1^(###)^###- (where ^ is a space).
But that format will (inappropriately) lose
Vince,
If you want the format of 1 (123) 456-7890 simply type in the format definition
box (near the bottom of the pop up menu for Format Cell under the Numbers tab)
1^(###)^###- (where ^ is a space). There is no need for quotation marks.
You can put any text you want when you are defining
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,
18 matches
Mail list logo