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 value.

Excel is known for automatically formatting certain entries, which is often useful but sometimes annoying. This automatic function can now be deactivated on an individual level. We'll show you how.