Thursday, January 22, 2015

Present negative numbers with minus sign or with parenthesis

1. Go to Control Panel
2. Click on Region and Language
2. Click the Addition settings… button at the bottom of the Formats TAB


4. Click the Numbers TAB and in the Negative number format option change
    the 
way negative numbers will be presented in Excel.
    This change will also be applied on cells with Accounting format.


* * *

Friday, December 26, 2014

Multiplying hours and dollars

In order to obtain the right results of Dollar X Hours calculations in cell C12, the total hours of cell C10 must be multiplied by 24 to compensate on the way that Excel is handling cells with time format. Thus C12 should have the formula C10*24*C11.



* * *