Negitive Numbers

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

Guest

How do I formate a cell so the number will always be negitive w/o using a
negitvie sign.
 
Format cells using Custom and then enter -# in the "Type:" dialog box.

John
 
One number format of many possible ones is: -#,##0;-#,##0;0

But we aware this makes a number "appear negative", not "be negative". A
positive number will still be positive for purposes of math operations, as
indicated by what you see in the formula bar.
 
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

spreadsheet with negitive numbers 1
Excel change a group of positive numbers to negitive numbers 3
negitive and possitive numbers 4
Negitive Numbers 1
Always negitive 2
How can I get a defalt of a negitive number for a cell? 1
Coloring cells based on positive or negitive numbers 2
Help with Formula 4

Back
Top