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.
Report Abuse. Right Click the cell and choose Cell Formatting. On the Number tab you will see that you can choose the format for negative numbers, choose the one with the parentheses (18.99). OR Just type ' (single quote) before you start to type your number in parentheses...this will make excel treat the number like text and display EXACTLY what you type.eport Abuse. Right Click the cell and choose Cell Formatting. On the Number tab you will see that you can choose the format for negative numbers, choose the one with the parentheses (18.99). OR Just type ' (single quote) before you start to type your number in parentheses...