Learn how to use either of these methods in Microsoft Excel to display negative values in red. To enter a negative value into a Microsoft Excel sheet, precede the value with a hyphen character, (-), ...
When you apply Microsoft Excel's percentage number format to a cell already containing a number, it multiplies the value by 100. This can be frustrating, as there's apparently no easy way to stop this ...