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.
So continue reading below to learn how to make negative numbers red in Excel 2010. Step 1: Open your worksheet in Excel 2010. Step 2: Highlight the cells containing the information that you want to format with the automatic red font for negative numbers.Step 2: Click the Home tab at the top of the window. Step 3: Click the Format Cells: Number button at the bottom-right corner of the Number section of the ribbon.Step 4: Select the Number or Currency option from the list at the left side of the window.Note that choosing the currency option will place a $ sign in front of any number in the spreadsheet. Step 5: Select the 1234.10 option under Negative numbers, then click the OK button.o continue reading below to learn how to make negative numbers red in Excel 2010. Step 1: Open your worksheet in Excel 2010. Step 2: Highlight the cells containing the information that you want to format with the automatic red font for negative numbers.