How to Format a Phone Number in a Numbers Spreadsheet

Save

A spreadsheet is an application that includes rows and columns of cells, allowing you to insert, manage and analyze data. Microsoft Excel, OpenOffice Calc and EditGrid are some examples of spreadsheet applications. When you insert a number into a spreadsheet, you can instruct your spreadsheet to format it in a certain way. You can format a single cell or multiple cells containing phone numbers or other types of data.

Microsoft Excel

  • Select the cell containing the phone number you want to format.

  • Click on "Format" and "Cells" in the toolbar in Excel 2003. In Excel 2007, select the "Home" tab and expand "Number Format." Choose "More Number Formats" from the bottom of the list.

  • Select the "Number" tab and the "Special" category. Select "Phone Number" from "Type" and press "OK."

OpenOffice Calc

  • Select the cell containing the phone number. Select "Format" and "Cells" from the toolbar.

  • Go to the "Numbers" tab and choose "User-defined" from "Category."

  • Go to the "Format code" text box and type in the phone number format you want to use. To display the phone number with the (123) 456-7890 format, type (000) 000-0000. To display the format as 123-456-7890, type the format as 000-000-0000. Press "OK."

EditGrid

References

  • Photo Credit phone pad image by palms from Fotolia.com
Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!