Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or
0
0
0
s2smodern

How to convert zeroes to dashes in Excel?

If you have a range of values which populated with some zeroes, and now you want to convert theses zeroes to dashes in your data range. How could you change all the zeroes to dashes at once in Excel?

Convert zeroes to dashes with Format Cells function

Convert zeroes to dashes with Kutools for Excel


arrow blue right bubble Convert zeroes to dashes with Format Cells function


In Excel, the Format Cells function can help you to complete this task.

1. Select the data range that you want to change the zeroes to dashes.

2. Then right click to choose Format Cells from the context menu, see screenshot:

doc-convert-0-to-dashes-1

3. In the Format Cells dialog box, under Number tab, click Custom from the Category list, and enter 0;-0;—;@ into the Type text box. See screenshot:

doc-convert-0-to-dashes-1

4. And then click OK, all zeroes have been replaced by dashes in the original range. See screenshots:

doc-convert-0-to-dashes-3 -2 doc-convert-0-to-dashes-4

arrow blue right bubble Convert zeroes to dashes with Kutools for Excel

If you have installed Kutools for Excel, its Select Specific Cells feature can help you to select all zeroes cells first, and then convert all zeroes to dashes immediately.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now

1. Select your data range that you want to convert the zeroes to dashes.

2. Click Kutools > Select Tools > Select Specific Cells, see screenshot:

doc-convert-0-to-dashes-1

3. In the Select Specific Cells dialog box, click Cell option under Selection type, and from the Specific type drop down list, choose Equals and enter 0 into the text box. See screenshot:

doc-convert-0-to-dashes-1

4. Then click OK, and al zeroes have been selected as following screenshot shown:

doc-convert-0-to-dashes-1

5. And then enter the – dash symbol, and press Ctrl + Enter keys together, all the zeroes have been converted to dashes, see screenshot:

doc-convert-0-to-dashes-1

Click to know more about this Select Specific Cells feature.

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.