Always negitive

  • Thread starter Thread starter HessInAMess
  • Start date Start date
H

HessInAMess

is there a way to tell excel to always make any numbers in a cell
negitive? even when the number wasn't entered with a - sign? I've been
trying to use the format cells options to do this and using the custom
formats i can have it add a - sign in front of the number but it
doesn't actually make the number negitive.
 
Hi
if you want to change them you'll need VBA to scan all cells and negate
the values if required.

But if you just want to use them for further calculations you may use
something like
=-ABS(A1)
 
Thanks, i finally got it all working. i appreciate your help. I was
able to use =-SUM to add together the cells i wanted and then turn it
to a negitive number.
 

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
negitive and possitive numbers 4
Negitive Numbers 2
How can I get a defalt of a negitive number for a cell? 1
Time - 2 things: Average mm:ss.00, Negitive Times 5
Coloring cells based on positive or negitive numbers 2
Negitive Numbers 1
Longitude and Latidude Formatting 2

Back
Top