Excel's SWITCH is a logical function that is primarily used for data manipulation. It evaluates an expression against a list of values, and returns a result corresponding to the first matching ...

Open the Excel 2010 file that you want to make format changes to. Select the top-left cell in the range of cells that you want to change to the accounting format.

How Do I Change Hours & Minutes Into a Decimal Number in Excel?. In addition to its basic spreadsheet functions, Microsoft Excel also allows writing formulas to perform functions on existing data.