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.
Change Negative Number Formats. Select a number or range of numbers to change the way Excel displays these numbers. Click the Home tab on the top menu and select the arrow in the Number section. Choose either the Number or the Currency category in the Category: list in the Format Cells window.nter a negative number into an Excel spreadsheet cell by using the minus sign (-) before the number. -12 is an example of a negative number. Use the arithmetic operator, the minus sign (-), to subtract a number using a formula. An example is the formula, =25-10 that will give a result of 15..