Not possible to add Zero at the left side within excel cell

Asked By annarforster 50 points N/A Posted on - 07/17/2012

Hi,

I have got 500 faxing contacts listing from ms excel to outlook 2007. Fax broadcasting is our plan to implement through “win fax pro 10.02”. The fact is 0 can not be attached at the left side within excel cell. For automatic running of fax broadcast we have to add 0 then will have to dial the following numbers. How could it be solved without dialing every time manually?

Thank you for your assistance

• Status: Open
• Question Views: 1199
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Lornel faop

Go To Solution

Best Answer

Best Answer

Answered By Lornel faop 0 points N/A #141424

Not possible to add Zero at the left side within excel cell

Following are some instructions to solve your problem:

1. Click the cell on your worksheet that you wish to display and start it with number 0 to select the whole column or row. And then click a letter or a number from the top or the side of your worksheet or just simply press Ctrl+A to highlights the entire worksheet.

2. Right-click the cell that you just click on Step 1, or any cell on the highlighted cells and then click the Cells option on the dialog.

3. Under the Number tab, click Custom in the category area on the left pane of the Format Cells box.

4. Click the number 0 on the panel located at the right portion of the box. On the text field on top of the panel straight under the cup type, enter number of zeroes of the highest digits that you need to go for an item on your worksheet implies. Such as: 00000 if you wish to add five digits number. If you type 123 on the cell, Excel will automatically add zeros that will result to 00123.

5. Click OK to save the settings.

 

 

About Lornel faop

Questions
0

Answers
16

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/18/2012
• Question Category: MS Excel

Answered By Denise Dinkel 5 points N/A #141425

Not possible to add Zero at the left side within excel cell

 

It is simple to make zeros displayed in Excel sheet if they are first. Highlight wanted range of cells, right click mouse button on them, select “Format Cells” and under the “Number” tab, in Category list choose “Text”, and click OK. You are now able to see 0 if first in number.

About Denise Dinkel

Questions
0

Answers
101

Best Answers
36

• Vote Up 0 Vote Down

• Posted on - 10/21/2012
• Question Category: MS Excel