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.
Once the cell is selected, then you can use the ActiveCell property to change its value or other properties. Update Excel values in VBA. Launch Microsoft Office Excel and type data in A1 in cell A1. Click the Developer tab, and click Visual Basic to open the VBA Editor Window. Click the Insert menu, and click Module to insert a new module. Create a new String variable by typing the following: Dim data As String. Copy and paste the following code to change the value in cell A1: