formatting phone numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
(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
 
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
 
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.
 
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.
 
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.
 
Norman Harker said:
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.
Click to expand...

Discontiguous??

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

Bob
 
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.
 
Norman Harker said:
It's in my Oxford English Dictionary (full version). Not sure about
other editions.
Click to expand...
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.
Click to expand...

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.;
 
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.
 
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
Click to expand...

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

Just in case you some numbers without area codes.


--ron
 
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.
 
But they all end with:

This is by design.



Norman said:
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)
Click to expand...
 
Norman Harker said:
Production of first full edition was started 1878 but wasn't published
until 1933. And they didn't have Office to assist!
Click to expand...
....

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.
 
Bob Phillips said:
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.
Click to expand...
....

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.
 
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????
 
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
 
Back
Top