How to Remove Leading Zeroes in Excel

Techwalla may earn compensation through affiliate links in this story.
You can use custom cell formats to specify the appearance of spreadsheet data.

Microsoft's Office Excel spreadsheet program offers a wide range of data storage, analysis and calculation tools. Excel also offers customizable display options, including the capability to present data in various chart, graph and text forms. By default, decimal data in Excel is always presented with a leading zero before the decimal point. If you want to remove the leading zero in an Excel spreadsheet, you'll need to format the desired cells with a custom format type.


Step 1

Open the spreadsheet that you want to edit in the Microsoft Excel program.

Video of the Day

Step 2

Highlight the cells that contain decimal information for which you'd like to remove the leading zero.


Step 3

Right-click the highlighted cells and choose "Format Cells." This will open a cell-formatting options window.

Step 4

Click the "Number" tab and select "Custom" from the category list.


Step 5

Click the text box underneath the "Type" heading and press the "Backspace" key multiple times to clear the contents of the field.


Step 6

Type a decimal point and then type the number of zeroes that correspond to the number of decimal places that you want to display in the cells. For instance, to display three decimal places with no leading zero, you would input: .000.


Step 7

Click the "OK" button to save your changes. The decimal information in the formatted cells will now be displayed without a leading zero.



Report an Issue

screenshot of the current page

Screenshot loading...

Get the latest news and alerts!