Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Phone number format (https://www.askmehelpdesk.com/showthread.php?t=178968)

  • Jan 31, 2008, 12:04 PM
    jody wyttenbach
    Phone number format
    I need to change the format of phone numbers in excel from the standard 000-000-0000 to #10000000000.
  • Jan 31, 2008, 06:39 PM
    litelegs
    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?
  • Feb 1, 2008, 02:41 AM
    JBeaucaire
    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.

  • All times are GMT -7. The time now is 03:16 AM.