Excel also lets you combine direct numbers and cell references in the same formula. For example, if you want to add 50 to the value in cell C1 , your formula would look like this: =C1+50 .

To add a zero after a number in Excel, you can use the CONCATENATE function. For that, you need to choose a cell and enter this formula: =CONCATENATE(A1, “000”).

In Excel, you can format a negative number by creating a Conditional Formatting rule. Select the range of cells containing the numbers. On the Home tab, in the Styles group, click the Conditional ...