How do i get excel to display the number 0?

Question

For like telephone numbers, they start with 0, so say if i wanted to type the number 07771111111 then when i type that into a cell the 0 goes and im left with a telephone number that reads 7771111111. I want the 0 to stay, how do i do this?

Answer 1

Change the format of the Cell to Text. It will display every character then. Hope this helps...

Answer 2

1

Answer 3

Excel Phone Number

Answer 4

I've tried every formatting option that I can think of (format, cell, etc), and there is nothing that works, including formatting the cell as text only.

So, the only thing that I can think of is to use another way to trick Excel. This won't work if you intent is to have your computer auto-dial phone numbers for you. But if this is a database from which someone is manually dialling, simply enter the number with a decimal in front. You'll have to format the cells for the number of decimal places that are equal to the number of digits in the phone number, and then enter it as .07771111111

I tried davey_ramsey's trick, and found that that option has always had a tick. But I still can't get that leading 0 to be accepted.

For greggblack0590. this may depend on the version of Excel that you've been using. I'm using XP, and it doesn't work. In fact, when I used both davey_ramsey's trick and greggblack0590 trick, and went to Control Panel, Regional and Language Options, Regional Options, Customize, Numbers, Display Leading Zeros, and changed my options to actually show those leading zeros, it still didn't work. It's also possible that Microsoft may have a slightly different variation for the military, but this is just speculation on my part.

Now, let's all of us start lobbying Microsoft to tweak their Format - Cells - Custom - Phone Numbers function to allow for leading zeros. This is actually essential for international calls, and may well be needed within some countries as well.

Answer 5

Reverse Phone Number Look Up Services

Answer 6

The absolutely free reverse phone lookup sites generally provide the most basic of information such as name and it works only for landlines. To get further information, money will have to be paid. The free searches do not provide much more than what can be found through the phone book or personal knowledge and they only want your email to send spam. Stay away from shady reverse phone lookup sites, most likely you won't get any information after you make the payment. Not to mention you won't get a report and you won't get an answer if you try to call for a refund. Stick with a reputable reverse phone lookup site like ( http://reversephones.info ) that has been around since 1999. If I recall correctly they have two options: or you get only one report or for $39 you get unlimited reports. I went with this option because I wanted to verify more numbers. This is how I caught my girlfriend cheating, I got the name, other phone number, address history, relatives, and criminal-court records.

Answer 7

what the first two said. If you want the number to BE a number, use the formatting trick (and bear in mind that you may need to put the zero back, as excel may have junked it). If you want it to merely look like a number, and actually be text, use the single quote.

Answer 8

excel will autoformat the cell to number, and will remove the 0 in the front.

by hitting ' (key immediately left of enter) it tells excel to keep this as a text cell.

that should solve the problem.

Answer 9

You can either change it to text by right clicking it and hitting Format Cells, or choose Custom and enter 0's for every digit you want displayed.

Answer 10

For the best answers, search on this site https://smarturl.im/aD1HE

There's no numerical value 011309 - numbers don't have leading zeros, only text does. You could do it with a formula, but it gets messy. Add a few zeros to the left and take the rightmost n characters: =RIGHT(CONCATENATE("00000",A1), 6) will give you 6 characters with zero-fill on the left, from a numeric or text cell. Edit: Or you could use a custom format of "000000" for the same effect.

Answer 11

All Zero can be displayed quickly and easily, and they stay as Numbers if you placed them or are a result of calculation.

Tools=> Options=> View Tab, at the bottom middle is.. Zero Values.. Place a tick in there. Then OK