How to insert a Phone Number into Excel 2007?

0	How can I insert a phone number like 07111111111 into a cell without the 0 disappering?! I need to make a contact database. Help is appreciated! Thanks, Patrick excel apple office asked Oct 18 '11 at 07:17 TheGeekPanel 196●46●50●56

One Answer:

oldest newest most voted

The easiest way is by simply typing a ' before the number. So, if you type '07111111111 it will simply appear as 07111111111. Or you can change the input type to 'Text' and it will simply display the number as text, and therefore won't get rid of the 0.

answered Oct 18 '11 at 07:28

Zane Harnish
246●10●12●20

Your answer

toggle preview

community wiki

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or __italic__
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown