Ask Experts Questions for FREE Help !
Ask
    jody wyttenbach's Avatar
    jody wyttenbach Posts: 1, Reputation: 1
    New Member
     
    #1

    Jan 31, 2008, 12:04 PM
    Phone number format
    I need to change the format of phone numbers in excel from the standard 000-000-0000 to #10000000000.
    litelegs's Avatar
    litelegs Posts: 33, Reputation: 1
    Junior Member
     
    #2

    Jan 31, 2008, 06:39 PM
    I think if you just go to format-cell and click on the "general" under category the number will appear as 4548675309. Is that what you were looking for?
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Feb 1, 2008, 02:41 AM
    If your example is EXACTLY what you want, the #1 added to the beginning of a typed in 10 digit telephone number, do this:
    • Highlight the cells
    • FORMAT > CELLS > NUMBER > CUSTOM
    • in the TYPE box, enter: "#1"0000000000
    • Select FORMAT > CONDITIONAL FORMATTING
    • Cell Value is / less than / 999999999 (that's nine nines)
    • Click on FORMAT and set the color to RED

    Try it out now. If you enter a perfect 10 digit number it will add the #1 to the beginning. But if you do not enter enough digits, the data will appear in RED and you know you need ot fix it.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Is there a phone number [ 1 Answers ]

Is there a phone number for the Family Court in Charleston,WV?

Phone number [ 3 Answers ]

What is a phone number for Yahoo?

Changing disconnected phone line to same number as phone line that is active [ 3 Answers ]

If you can help I will vote for you... for any office... state or government! We have two separate phone lines. One for one room and one for another. One of the lines was cut off at our request by the phone company. We want to make the disconnected line active again and work on the same number...


View more questions Search