Zero's

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Displaying zeros in cells 2
Cell formulas display "0" (zero's) 3
Display zero in the cells with Excel 2013 5
Incorrect logic evaluation 4
=if formulae 2
How to enter zip starting with 0 (zero) 10
Zero Upload Speed 6

Back
Top