Home > Solution Categories > Microsoft Office > MS Excel > Not possible to add Zero at the left side within excel cell
Question
No of visitors who read this post: 327
Category: MS Excel
Type: Question
Author: Annarforster
No votes yet

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# (Solution Accepted)

Submitted by Lornel faop on Wed, 2012-07-18 15:28. Comment Id: 69190

Following are some instructions to solve such problem

1
Click the cell in an Excel worksheet that you want to display leading zeros in order to select the entire column or row, click a letter or number along the top or side of the worksheet, or press "Ctrl "and" A "together to select the entire worksheet.
 
2
Right-click the cell you selected in step 1, or on one of the highlighted cells of a selected group, and click on "Cells" to a dialog.
 
3
Click on the "Number" tab and click on "Custom" in the category pane on the left of the Format Cells box.
 
4
Click on the number "0" in the type of panel, on the right side of the box. In the text box at the top of the panel directly below the cup type, enter a number of zeros that the maximum number of digits that you plan to go for an item in your worksheet indicates. For example, type "00000" if you want any number five digits long. In this case, if you type the number "123" in a cell, Excel will add zeros to "00123".
 
5
Click "OK" to save the custom format and Enjoy.

#

Submitted by Denise Dinkel on Sun, 2012-10-21 12:24. Comment Id: 95830

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.

Previous Previous Page
407 of 862
Next Page Next