How to Remove Leading or Trailing Zeros in Excel

Table of contents:

How to Remove Leading or Trailing Zeros in Excel
How to Remove Leading or Trailing Zeros in Excel
Anonim

This article teaches you to remove zeroes at the beginning or end of a digit in Excel.

Steps

Method 1 of 2: Remove Leading Zeros

Remove Leading or Trailing Zeros in Excel Step 1
Remove Leading or Trailing Zeros in Excel Step 1

Step 1. Highlight cells with leading zeros

If you want to work on the numbers of an entire column, highlight it by clicking on the corresponding letter in the column header.

Remove Leading or Trailing Zeros in Excel Step 2
Remove Leading or Trailing Zeros in Excel Step 2

Step 2. Right click on the highlighted cells

If the mouse does not have a right button, press the Ctrl key while left clicking. A menu will appear.

Remove Leading or Trailing Zeros in Excel Step 3
Remove Leading or Trailing Zeros in Excel Step 3

Step 3. Select Format Cells

The "Format Cells" dialog box will appear.

Remove Leading or Trailing Zeros in Excel Step 4
Remove Leading or Trailing Zeros in Excel Step 4

Step 4. Select Number from the left column

Remove Leading or Trailing Zeros in Excel Step 5
Remove Leading or Trailing Zeros in Excel Step 5

Step 5. Type a "0" (zero) in the "Decimal places" box

Remove Leading or Trailing Zeros in Excel Step 6
Remove Leading or Trailing Zeros in Excel Step 6

Step 6. Click OK

It is in the lower right corner of the dialog box. This action takes you back to your spreadsheet, where numbers will no longer have leading zeros.

If you still see zeros, double-click the cells, then press Enter

Method 2 of 2: Remove trailing zeros

Remove Leading or Trailing Zeros in Excel Step 7
Remove Leading or Trailing Zeros in Excel Step 7

Step 1. Highlight cells with trailing zeros

If you want to work on the numbers of an entire column, highlight it by clicking on the corresponding letter in the column header.

Remove Leading or Trailing Zeros in Excel Step 8
Remove Leading or Trailing Zeros in Excel Step 8

Step 2. Right click on the highlighted cells

If the mouse does not have a right button, press the Ctrl key while left clicking. A menu will appear.

Remove Leading or Trailing Zeros in Excel Step 9
Remove Leading or Trailing Zeros in Excel Step 9

Step 3. Select Format Cells

The "Format Cells" dialog box will appear.

Remove Leading or Trailing Zeros in Excel Step 10
Remove Leading or Trailing Zeros in Excel Step 10

Step 4. Select Custom from the left column

Remove Leading or Trailing Zeros in Excel Step 11
Remove Leading or Trailing Zeros in Excel Step 11

Step 5. Type a code in the box under "Type"

If there is already text, delete it. Then type the sequence 0. ### in the box.

Remove Leading or Trailing Zeros in Excel Step 12
Remove Leading or Trailing Zeros in Excel Step 12

Step 6. Click OK

At the bottom of the numbers you will no longer see zeroes.

Recommended:

How to Insert Double Leading in Word 2007

How to Insert Double Leading in Word 2007

When writing an important document in Microsoft Word 2007, double spacing is often required, or preferred to use, to increase readability and ease of revision of the text. You can apply double spacing to both the entire document and a specific piece of text.

How To Stop Excel From Automatically Removing Non-Significant Zeros From Numeric Values

How To Stop Excel From Automatically Removing Non-Significant Zeros From Numeric Values

Excel automatically removes leading zeroes (those placed to the left of an integer and those placed at the end of a decimal number). If this feature has a negative impact on the values you need to store in your file, for example numbers such as zip codes, you can import the values as text, so they are displayed correctly.

How to Use a Trailing Stop Loss: 3 Steps

How to Use a Trailing Stop Loss: 3 Steps

To "make profits run" and "minimize losses", it is useful to learn how to use stop-loss! The stop-loss is an automatic mechanism to order the sale of a security. For example, if you buy a stock worth 100 and don't want to run the risk of losing too much money if it crashes on the stock market, it is a good idea to set a limit price at which to sell to limit your losses.

How to Change the Leading Line in a Microsoft Word Document

How to Change the Leading Line in a Microsoft Word Document

Changing the line spacing makes a Word document easier to read and allows you to insert annotations once printed. Choose one of the methods described below if you want to change the line spacing in a Word document using any operating system.

4 Ways to Set Double Leading in Pages

4 Ways to Set Double Leading in Pages

Apple's Pages program is a word processing application with functions similar to Microsoft Word. Pages uses both the Formatting toolbar and the Document toolbar to change the format and layout of a file. By learning how to use these menus, you will be able not only to double-spacing with Pages, but also to change margins, paragraph spacing, and tab stops.