How does one change the sample number. Instead of zero my workshe.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My Excel work sheet displays a -1 when it should read zero. When right click
and go to format cells and number I see that a -1 is in the sample section.
However, I can not change it to zero.
 
John

Why do you think it should read zero?

What value is in the cell? A computed value that you feel should be zero?

If you type in a zero you should see 0

If you type in -1 you will see -1


Gord Dibben Excel MVP
 
Hi John

what is in the cell? is it a formula, if so could you copy & paste the
actual formula in your reply post and detail the appropriate cell values
that are feeding into this formula.
 
You must log in or register to reply here.

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

Need 7 digit number with differnt number of leading zeros 10
Number format 1
Number Formatting 1
Pivot Table Shows Only Zeros 3
Why does the initial zero in "01625" in a number cell disappear? 2
How to stop Excel from automatically truncating leading zeros 2
How do I stop Excel from dropping leading zeros? 9
linking sheets in the workbook and getting rid of the ZERO 3

Back
Top