formatting phone numbers

[Guest]

Hi, how do you get Excel to format phone numbers with parentheses and dashes? I know you go under format, cells, and I know it says something about phone numbers but I can't get it to insect the parentheses and dashes. If someone can help me with this, I would really appreciate it. Thanks, Mindy

 

[Norman Harker]

Hi Mindy!

You could use a custom format like:

(0###) ###-###

Since this is a number, you need that first 0 to prevent dropping it
if the number starts with a 0.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

(000)-000-0000

----- Mindy wrote: -----

Hi, how do you get Excel to format phone numbers with parentheses and dashes? I know you go under format, cells, and I know it says something about phone numbers but I can't get it to insect the parentheses and dashes. If someone can help me with this, I would really appreciate it. Thanks, Mindy

 

[Guest]

I tried that and after I put the number in and pressed enter it puts ######
----- Norman Harker wrote: ----

Hi Mindy

You could use a custom format like

(0###) ###-##

Since this is a number, you need that first 0 to prevent dropping i
if the number starts with a 0

--
Regard
Norman Harker MVP (Excel
Sydney, Australi
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments
available free to good homes

 

[Norman Harker]

Hi Mindy!

This should be resolved if you increase the cell width.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Guest]

It worked for one cell but when I try to coy it down the column, it does nothing. I'm getting ready to call it a night but could we continue this discussion tomorrow night? You can email me at (e-mail address removed)

Thanks,
Mindy
----- Norman Harker wrote: -----

Hi Mindy!

This should be resolved if you increase the cell width.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Norman Harker]

Hi Mindy!

Try selecting a block of cells that you want the formatting in and
then using Format > Custom etc on the block.

Also if you have got one cell working OK, you can use the Format
painter:

Select a cell
Click the format painter button (It has a paste brush on it)
Click the cell you want to copy the format to.

If you double click the format painter you can apply formatting by
clicking on discontiguous cell (click once on the format painter when
you're done.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Hi Mindy!

If you double click the format painter you can apply formatting by
clicking on discontiguous cell (click once on the format painter when
you're done.

Discontiguous??

I've heard of American English, but Strine English as well now? Lord help
us<vbg>

Bob

 

[Norman Harker]

Hi Bob!

S'not Strine Mate! It's the Real McCoy English.

It's in my Oxford English Dictionary (full version). Not sure about
other editions.

"a. Not contiguous, not in contact; consisting of parts not in
contact"

In the context of the reference to cells I was suggesting that they
don't need to be in a range.

Straylians would of said, "Click onasmany cellsas y'like wherever!
Mate!"

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

It's in my Oxford English Dictionary (full version). Not sure about
other editions.

I don't have access today (it's Sunday) to an OED, but I couldn't find it in
any other dictionary I do have access to.

In the context of the reference to cells I was suggesting that they
don't need to be in a range.

Yes, I know what non-contiguous means <vbg>.

We've had other discussions about language, I guess it's time for another
sigh, and move on.

Heard an interesting radio programme recently, about the initial creation of
the OED (I think that there is a book about it too). Apparently there were
many top academics employed on the definitions for the first edition, and
towards the end they also recruited a young man called Tolkein, who was
assigned the letter W. So he was defining words like Warlock, and Wizard.
Interesting conjecture to think that a seed may have been cultivated in the
creation of the OED.;

 

[Norman Harker]

Hi Bob!

That anecdote wouldn't surprise me.

Tolkien was Merton Professor of English Language and Literature,
Oxford.

Production of first full edition was started 1878 but wasn't published
until 1933. And they didn't have Office to assist!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ron Rosenfeld]

Hi, how do you get Excel to format phone numbers with parentheses and dashes? I know you go under format, cells, and I know it says something about phone numbers but I can't get it to insect the parentheses and dashes. If someone can help me with this, I would really appreciate it. Thanks, Mindy

[<=9999999]###-####;(###) ###-####

Just in case you some numbers without area codes.


--ron

 

[Debra Dalgleish]

And a greater authority than Oxford says it's a real word:

How to Create a Chart with Discontiguous Ranges
http://support.microsoft.com/?kbid=146058

How to Populate an Array with a Discontiguous Range
http://support.microsoft.com/?kbid=149831

XL2000: Glossary of Charting Terminology
http://support.microsoft.com/?kbid=214240
"Nonadjacent Selections -- Also called discontiguous selections;
data that is separated by other data or blank rows or columns not
to be used in the chart."

 

[Norman Harker]

Hi Debra!

Re: "And a greater authority than Oxford"

I suppose I must concede. The combined content of KB articles must be
now greater than the 17 volume Edition of the Oxford.

 

[Dave Peterson]

But they all end with:

This is by design.

Hi Debra!

Re: "And a greater authority than Oxford"

I suppose I must concede. The combined content of KB articles must be
now greater than the 17 volume Edition of the Oxford.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

 

[Debra Dalgleish]

Do they start with, "In the beginning..."?

But they all end with:

This is by design.

 

[Harlan Grove]

Production of first full edition was started 1878 but wasn't published
until 1933. And they didn't have Office to assist!

....

Yes, truly a mystery how the human race was able to develop the technology
needed to produce Office without having Office to develop that technology.
You might almost get the impression that it isn't actually necessary for
human progress.

 

[Harlan Grove]

I don't have access today (it's Sunday) to an OED, but I couldn't find it in
any other dictionary I do have access to.

....

Contiguous is in Merriam-Webster (so just US usage), but discontiguous
isn't.

Neither is antidisestablishmentarianism, but establishmentarianism is in it
as a noun derived from establishmentarian.

 

[Dave Peterson]

Maybe, if this were a Word group. (ouch!).

But this just doesn't scan:
In the beginning was the excel....

I think J.E. wrote that or some other John????

 

[mtk111]

I have columns of 10 numbers I want to convert to this format. Selecting
the numbers and than the proper format does not change the format of
multiple numbers. IK esperienced a change in as many as 2 rows but no
more. Is there a way to change the data in the whole column of over 800
lines at one time? I found if i retype the number in, it will format
properly but I don't want to reenter data if I don't have to.
Thanks,
Mike