Indeed, for some gems, such as diamonds, the price per carat can increase exponentially as the gem size increases. Therefore, a 1 carat stone may cost $1,000 while a 2 carat stone may cost $4,000. This means that good quality sapphires and rubies in larger sizes tend to have a much higher price per carat.
Re: Convert positive # to negative. Hi, if you positive number is in A1, use the following formula to convert it to a negative number =A1*-1 Time values can not be negative. Microsoft MVP http://www.teylyn.com Twitter: http://twitter.com/IngeborgNZ. Microsoft MVP.
Best Answer: In much of the finance world, negative numbers are put in parentheses instead of prefixed with a negative sign. I suppose it's easier for them to distinguish at a glance. You can change the formatting for those cells so it applies parentheses instead of negative signs (or even both). keep trying to open a spreadsheet that has numbers in parentheses. Everytime I do, it changes those numbers to negative numbers. I'd kind of like to make it so that it doesn't fix these numbers by default. It is a real pain to go through and fix each one individually. I know how to keep it...