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

Asked By 50 points N/A Posted on -
qa-featured

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

SHARE
Best Answer by Lornel faop
Best Answer
Best Answer
Answered By 0 points N/A #141424

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

qa-featured

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.

 

 

Answered By 0 points N/A #141425

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

qa-featured

 

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.

Login/Register to Answer

Related Questions