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
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
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
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 Fe
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
D
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 a
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 punctuat
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 us
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 <64a75984-4f03-422e-
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 0
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 lead
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 to
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 sig
At 20:41 16/12/2021 +, Ralph McCrum wrote:
Good Luck Ken [who asked to be able to turn off all automatic
formatting changes].
I DON'T want automatic bulleting or paragraph numbering And A Few
Other Things either. But After The Answers I Got On Bullets And
Numbering, I Never Ask About Anythi
Good Luck Ken.
I DON'T want automatic bulleting or paragraph numbering And A Few Other
Things either.
But After The Answers I Got On Bullets And Numbering, I Never Ask About
Anything Else.
I'll Be Watching To See If You Get Better Answers Than I Did
Ralph
-- Original Message --
From:
At 22:12 10/12/2020 +0100, Martin Groenescheij wrote:
The definition from PC Magazine
What is the difference between a hard and soft return in Word?
*Hard return*: Pressing the *Enter* key in
*Word* ends a paragraph. It's officially known
as typing a *hard return*. ... The *soft
return*, or *
Thanks, I'll check it out.
On Fri, Dec 11, 2020, 7:27 AM Rory O'Farrell wrote:
> On Fri, 11 Dec 2020 11:33:09 + (UTC)
> nicholas wrote:
>
> > Hi
> >
> > In an effort to create a document that can be printed in landscape
> as an 8.5 x 5.5 folding book, I have been struggling with the
On Fri, 11 Dec 2020 11:33:09 + (UTC)
nicholas wrote:
> Hi
>
> In an effort to create a document that can be printed in landscape as an
> 8.5 x 5.5 folding book, I have been struggling with the page set up.
>
> Top and bottom margins are set at .59
> Left and right margins s
On 10/12/2020 18:33, Brian Barker wrote:
At 21:05 10/12/2020 +1000, Jean Lear wrote:
I knew there were Hard Returns and Soft Returns but never consciously
used them. I now have to understand which, when and where to use them
as I add items to the Newsletter.
The terms "hard return" and "soft
At 21:05 10/12/2020 +1000, Jean Lear wrote:
I knew there were Hard Returns and Soft Returns but never
consciously used them. I now have to understand which, when and
where to use them as I add items to the Newsletter.
The terms "hard return" and "soft return" are probably unhelpful.
Indeed, W
Thank you to Martin and Brian I have now sorted this out.
I knew there were Hard Returns and Soft Returns but never consciously used
them. I now have to understand which, when and where to use them as I add
items to the Newsletter. I do not know how I have managed to format the
Newsletter for the
Brian
Thanks. That works.
Howard
On Mon, Aug 10, 2020 at 11:06 Brian Barker
wrote:
> At 10:42 10/08/2020 -0400, Howard Bennett wrote:
> >In Excel ...
>
> Excel is also available!
>
> >For instance, I might have 2 or 3 columns fall under the heading
> >Summer (weight, height, blood pressure).
At 10:42 10/08/2020 -0400, Howard Bennett wrote:
In Excel ...
Excel is also available!
For instance, I might have 2 or 3 columns fall under the heading
Summer (weight, height, blood pressure). I cannot find a way to center "Summer"
o Select the three cells which you want the main heading to
On 7/12/18 2:46 pm, Brian Barker wrote:
At 03:50 07/12/2018 +, John van Barneveld wrote:
I use 4.1.5 on Win10. Is it possible to set numeric formatting so
that 4 decimal places are displayed and if the value in a cell is
zero then that cell displays as Blank.
Yes; enter
[=0]"";0.
in
At 03:50 07/12/2018 +, John van Barneveld wrote:
I use 4.1.5 on Win10. Is it possible to set numeric formatting so
that 4 decimal places are displayed and if the value in a cell is
zero then that cell displays as Blank.
Yes; enter
[=0]"";0.
into the "Format code" box.
I trust this hel
On Mon, 30 Jul 2018 06:52:43 -1000
Joan Rawson wrote:
> I would like instructions about formatting
> johnrawsonpharmac...@gmail.com
>
You may find this document helpful:
https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students
--
Rory O'Farrell
Formatting what?
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
On Mon, Jul 30, 2018 at 11:52 AM, Joan Rawson
wrote:
> I would like instructions about formatting
> johnrawsonpharmac...@gmail.com
>
> -
At 23:44 02/03/2017 +, John van Barneveld wrote:
I have a spreadsheet with four sheets, the third
of which I want printed in landscape and the
rest in portrait. It seems when I set in
Format-Page it formats all four the same ...
Because you are modifying the page style which
currently ap
On 03/03/17 11:15 AM, Julian THOMAS wrote:
Sent from JT's iMini - using voice dictation!
On Mar 2, 2017, at 18:44, John van Barneveld wrote:
This is fine for printing but I want to save a four page .pdf with the one page
as landscape. Can anyone tell me how to go about this please.
Brut
Sent from JT's iMini - using voice dictation!
> On Mar 2, 2017, at 18:44, John van Barneveld
> wrote:
>
> This is fine for printing but I want to save a four page .pdf with the one
> page as landscape. Can anyone tell me how to go about this please.
Brute force solution: print the landscap
Tools --> Options --> Appearance ... Visited Links
On 3-3-2014 3:47, William K Helbig Jr wrote:
Can anyone please me how to format a hyperlink in a Calc cell to
appear the way I want it to, not just the way Openoffice wants?
Skip H
35 matches
Mail list logo
