Excel formatting numbers help

[sap1958]

I have a number such as
9894634858 in excel

I want the number to look like this
989.463.4858 It is actually a phone number.

I right clicked on the cell and chose Format Cells. I then chose Custom. This is where I get lost. Any ideas

 

[GlennUK]

then type a format of:
###-###-####

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[xlhelp]

Why not use the Special formatting available for Phone numbers? It's under the Numbers tab - "Special"


And if want to customize the way you are asking. Once you get to Custom, in the Type box: enter ###"."###"."####

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[GlennUK]

Note that Special formatting for Phone numbers does exist for every locale ... you may have to alter your locale to see it. Or just use a custom format as xlhelp says ( I used - instead of ".", silly me ).

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[AnotherHiggins]

I would generally recommend storing your phone numbers as text. I mean, you'll never have to add two phone numbers together, right? So why store them as numbers?

Also, if you have any international codes it could be a problem since leading zeros will be stripped from numbers (but not text).

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[SkipVought]

DITTO what John just posted.

faq68-6659

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}