Zero's

G

Guest

How do I make my worksheet display zero's as slashes (-)? One worksheet I
have does it but the other display's zero's and I've compared fonts, options,
everything and can not figure out the difference.
 
G

Guest

This is generally what you see when the cells are formatted as Accounting and
with no monetary symbol. Select a cell and click Format>Cells. The dialog
box that appears should confirm it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro - replace 2
Incorrect logic evaluation 4
Display zero in the cells with Excel 2013 5
Cell formulas display "0" (zero's) 3
=if formulae 2
Displaying zeros in cells 2
How to enter zip starting with 0 (zero) 10
Slashed Zero Special Character 3

Top